19、oracle慢sql查询

oracle慢sql查询

SELECT *
  FROM (SELECT SQL_TEXT,
               EXECUTIONS,
               ELAPSED_TIME / 1000000 AS ELAPSED_SECONDS,
               CPU_TIME / 1000000 AS CPU_SECONDS,
               FETCHES,
               DISK_READS,
               BUFFER_GETS,
               PARSE_CALLS
          FROM V$SQL
         WHERE EXECUTIONS > 0
         ORDER BY ELAPSED_TIME DESC)
 WHERE ROWNUM <= 20;