您现在的位置是：网站首页> 编程资料编程资料

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

2023-05-27 393人已围观

简介 Oracle查看逻辑读、物理读资源占用排行的SQL语句_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;
您可能感兴趣的文章:

上一篇：Oracle中查看慢查询进度的脚本分享_oracle_

下一篇：Oracle中实现MySQL show index from table命令SQL脚本分享_oracle_

相关内容

点击排行

本栏推荐

猜你喜欢

-六神源码网