通过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;