龙盟编程论坛 | 龙盟编程博客 | 无障碍搜索 | 云盘搜索神器
快速搜索
主页 > 数据库类 > Oracle 技术 >

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

时间:2014-10-31 11:32来源:网络整理 作者:网络 点击:
分享到:
这篇文章主要介绍了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, 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;

精彩图集

赞助商链接