Dear Experts,
Some Queries are running longer than usual.
We want to get which SQL Queries are running more than 24 hrs.
I am looking for better one to track SQL Statements which are running longer than 24 hrs
set linesize 170 pages 1000;
col "USERNAME|SID,SERIAL|MACHINE|STATUS" for a25;
SELECT username,sid, serial#,machine,status,TO_CHAR(CURRENT_TIMESTAMP,'HH24:MI:SS') AS curr,TO_CHAR(start_time,'HH24:MI:SS') AS logon,(sysdate - start_time)*24*60 AS mins
FROM V$SESSION_LONGOPS WHERE username is not NULL AND (SYSDATE - start_time)*24*60 > 1 ;
Any other Queries to find which SQL Statements are running longer than usual ?
Thanks in Advance.