- 找出最消耗资源的实时sql
SELECT *
FROM ( SELECT A.SID,
A.SQL_ID,
A.STATUS,
A.CPU_TIME / 1000000 CPU_SEC,
A.BUFFER_GETS,
A.DISK_READS,
B.SQL_TEXT,
B.SQL_FULLTEXT
FROM V$SQL_MONITOR A, V$SQL B
WHERE A.SQL_ID = B.SQL_ID
ORDER BY A.CPU_TIME DESC)
WHERE ROWNUM < 20;