526互联

19、oracle慢sql查询

发布时间 2023-12-05 16:42:45作者: 站着说话不腰疼

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;