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

各位用户为了找寻关于Oracle查看逻辑读、物理读资源占用排行的SQL语句的资料费劲了很多周折。这里教程网为您整理了关于Oracle查看逻辑读、物理读资源占用排行的SQL语句的相关资料，仅供查阅，以下为您介绍关于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;