性能监视sql

set pages 1000
break on address skip page
WITH TMP AS (
    SELECT * FROM (
        SELECT a.address, a.ELAPSED_TIME
        FROM   v$sqlarea a
        WHERE  executions  > 0
            AND buffer_gets/executions > 100000
        order by a.ELAPSED_TIME desc
    )
    WHERE ROWNUM <= 10
)
SELECT a.address, a.ELAPSED_TIME, t.sql_text
FROM   TMP a, v$sqltext t
WHERE  a.address = t.address
order by t.address, t.piece;