数据库 
首页 > 数据库 > 浏览文章

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

(编辑:jimmy 日期: 2024/11/25 浏览:3 次 )

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

上一篇:Oracle11g RAC开启关闭、设置归档小结
下一篇:安装Oracle10g遭遇ins_ctx.mk问题解决方法
友情链接:杰晶网络 DDR爱好者之家 南强小屋 黑松山资源网 白云城资源网 网站地图 SiteMap