Oracle常用性能分析语句

1.查询一天内最耗时的50条语句

SELECT *
FROM   (SELECT Trunc(a.ELAPSED_TIME/Decode(a.executions,0,1,a.executions)) ELAPSED_TIME,
                Trunc(a.buffer_gets/Decode(a.executions,0,1,a.executions)) buffer_gets,
                a.executions,
                 a.last_active_time,
                Trunc(a.disk_reads/Decode(a.executions,0,1,a.executions)) disk_reads,
                a.hash_value,
                a.sorts,
                a.sql_fulltext sql_text
        FROM   v$sql a where a.last_active_time>(sysdate-1) AND parsing_schema_name <>'SYS'
        ORDER BY 1 DESC)
WHERE  rownum <= 50;

2.待续