How to find long running query in oracle.
SELECT l.sid, l.start_time, l.username, l.elapsed_seconds
a.sql_text, a.elapsed_time
FROM v$session_longops l, v$sqlarea a
WHERE a.elapsed = l.elapsed_seconds
AND l.elapsed_seconds > 1
SELECT l.sid, l.start_time, l.username, l.elapsed_seconds
a.sql_text, a.elapsed_time
FROM v$session_longops l, v$sqlarea a
WHERE a.elapsed = l.elapsed_seconds
AND l.elapsed_seconds > 1
Comments
Post a Comment