JZTXT

oracle sql优化

发布时间 2023-11-18 20:36:44作者: AQ_0321
  1. 找出最消耗资源的实时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;