For help, the operation of the oracle how to view detailed record-CodePudding

V $sqlarea integrate the same SQL, such as can't see the same SQL statement, respectively, in which time point was carried out
And didn't find the record of a select statement in redolog

Want to see such a precise point in time - SQL statements

CodePudding user response:

V $SQL. Last_active_time

But also can see the latest active time

CodePudding user response:

reference 1st floor minsic78 response:

v $SQL. Last_active_time

But also can see the latest active time

However, if your query in the past, is compared, and system is busy, the cursor age out had been made, and that is more troublesome, going through DBA_HIST_ACTIVE_SESS_HISTORY and DBA_HIST_SQLTEXT checked

CodePudding user response:

refer to the second floor minsic78 response:

Quote: refer to 1st floor minsic78 response:

V $SQL. Last_active_time

But also can see the latest active time

However, if your query in the past, is compared, and the system is busy, the cursor age out had been made, and that is more troublesome, going through DBA_HIST_ACTIVE_SESS_HISTORY and DBA_HIST_SQLTEXT checked

This also tried, the result is not quite right

CodePudding user response:

reference qq_33913977 reply: 3/f

Quote: refer to the second floor minsic78 response:

Quote: refer to 1st floor minsic78 response:

V $SQL. Last_active_time

But also can see the latest active time

However, if your query in the past, is compared, and the system is busy, the cursor age out had been made, and that is more troublesome, going through DBA_HIST_ACTIVE_SESS_HISTORY and DBA_HIST_SQLTEXT checked

This also tried, the result is not quite right about

If the SQL execution soon, may see the lost in ASH,,,