云服务器网：购买云服务器和VPS必上的网站!

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

专栏 yuntue 2023年10月29日评论

查看逻辑读前10的SQL：set linesize 300;
set pagesize 300;
set long 50000;
SELECT *
FROM (SELECT sql_fulltext AS sql, SQL_ID,buffer_gets / e

查看逻辑读前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;

本文来源：https://www.yuntue.com/post/153922.html | 云服务器网，转载请注明出处！