檢視邏輯讀前10的SQL

set linesize 300;

set pagesize 300;

set long 50000;

SELECT *

FROM (

    SELECT sql_fulltext AS sql, SQL_ID,buffer_gets / executions AS "Gets/Exec",buffer_gets, executions

    FROM V$SQLAREA

    WHERE buffer_gets > 10000

    ORDER BY "Gets/Exec" DESC

)

WHERE rownum <= 10;

檢視物理讀前10的SQL

set linesize 300;

set pagesize 300;

set long 50000;

SELECT *

FROM (

    SELECT sql_fulltext AS sql, SQL_ID,disk_reads / executions AS "Reads/Exec",disk_reads, executions

    FROM V$SQLAREA

    WHERE disk_reads > 1000

    ORDER BY "Reads/Exec" DESC

)

WHERE rownum <= 10;

拿到SQL_ID,可以使用調整顧問,大致看一下最佳化
http://blog.itpub.net/29254281/viewspace-1080490/

Oracle檢視TOP SQL

相關文章