查看逻辑读前10的SQL：
http://www.cndba.cn/dave/article/1974http://www.cndba.cn/dave/article/1974

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：
http://www.cndba.cn/dave/article/1974http://www.cndba.cn/dave/article/1974http://www.cndba.cn/dave/article/1974http://www.cndba.cn/dave/article/1974http://www.cndba.cn/dave/article/1974

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;

版权声明：本文为博主原创文章，未经博主允许不得转载。