1.查看逻辑读前十的SQLhttp://www.cndba.cn/hbhe0316/article/5036http://www.cndba.cn/hbhe0316/article/5036http://www.cndba.cn/hbhe0316/article/5036

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;

2.查看物理读前十的SQLhttp://www.cndba.cn/hbhe0316/article/5036

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;

http://www.cndba.cn/hbhe0316/article/5036

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

Linux,oracle