oracle 如何分析语句,Oracle常用性能分析语句

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;