Oracle查看逻辑读、物理读资源占用排行的SQL语句

查看逻辑读前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,disk_reads / executions AS "Reads/Exec",disk_reads,executions
FROM V$SQLAREA
WHERE disk_reads > 1000
ORDER BY "Reads/Exec" DESC
)
WHERE rownum <= 10;

（编辑：4S站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!