查看逻辑读前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 Arraysize设置对于逻辑读的影响实例分析
- Oracle数据库逻辑备份的SH文件
- oracle逻辑运算符与其优先级简介