1. to get long running sql id
SELECT A.USERNAME,
A.MACHINE,
A.SID,
A.SERIAL#,
A.STATUS,
round(A.LAST_CALL_ET/60,2) AS MIN_WAIT,
a.sql_id,
substr(B.SQL_TEXT,1,100) as sqltxt,
a.inst_id
FROM GV$SESSION A,
GV$SQLAREA B,
1. to get long running sql id
SELECT A.USERNAME,
A.MACHINE,
A.SID,
A.SERIAL#,
A.STATUS,
round(A.LAST_CALL_ET/60,2) AS MIN_WAIT,
a.sql_id,
substr(B.SQL_TEXT,1,100) as sqltxt,
a.inst_id
FROM GV$SESSION A,
GV$SQLAREA B,