Oracle查看逻辑读、物理读资源占用排行的SQL语句
摘要：查看逻辑读前10的SQL：复制代码代码如下:setlinesize300;setpagesize300;setlong50000;SELEC...
查看逻辑读前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查看逻辑读、物理读资源占用排行的SQL语句】相关文章：
★ 探讨:Oracle数据库查看一个进程是如何执行相关的实际SQL语句
★ Oracle中简单查询、限定查询、数据排序SQL语句范例和详细注解