Execution Date time
Hi,
on 11.2.0.4, on AIX
I want to find Execution Date time of a query which I know sql_id from AWR report.
The following give no row:
SELECT s.sid, s.serial#, s.username, s.status, s.sql_id, s.sql_child_number, s.sql_exec_start,
s.sql_exec_id, q.sql_text
FROM v$session s
JOIN v$sql q ON s.sql_id = q.sql_id AND s.sql_child_number = q.child_number
WHERE s.sql_id = '<sql_id>';
Might it be found in another permanent tables?
Thank for help.