Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center