通过v$sql分析sql执行性能语句

 

通过v$sql分析sql执行性能语句

SELECT T.HASH_VALUE,
       T.EXECUTIONS,
       T.DISK_READS,
       ROUND(T.DISK_READS / T.EXECUTIONS) AS PERDISKREADS,
       T.BUFFER_GETS,
       ROUND(T.BUFFER_GETS / T.EXECUTIONS) AS PERBUFFERREADS,
       T.ELAPSED_TIME,
       ROUND(T.ELAPSED_TIME / T.EXECUTIONS) AS PERELAYTIME,
       T.CPU_TIME,
       ROUND(T.CPU_TIME / T.EXECUTIONS) AS PERCPUTIME,
       T.FIRST_LOAD_TIME,
       T.SQL_TEXT
  FROM V$SQL T
 WHERE (T.DISK_READS / T.EXECUTIONS > 500 OR
       T.BUFFER_GETS / T.EXECUTIONS > 20000)
   AND T.EXECUTIONS > 0
 ORDER BY 6 DESC;