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

前端技术 2023/09/01 Oracle

查看逻辑读前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.stayed.cn/item/3137

转载请注明出处。

本站部分内容来源于网络,如侵犯到您的权益,请 联系我

我的博客

人生若只如初见,何事秋风悲画扇。