oracle TOPSQL整理

**查看逻辑读前10的SQL

**

1. **set linesize 300;

**

1. set pagesize 300;

1. set long 50000;

1. SELECT *

1. FROM (

1. SELECT sql_fulltext AS sql, SQL_ID,buffer_gets / executions AS "Gets/Exec",buffer_gets, executions

1. FROM V$SQLAREA

1. WHERE buffer_gets > 10000

1. ORDER BY "Gets/Exec" DESC

1. )

1. WHERE rownum <= 10;

**查看物理读前10的SQL

**

1. **set linesize 300;

**

1. set pagesize 300;

1. set long 50000;

1. SELECT *

1. FROM (

1. SELECT sql_fulltext AS sql, SQL_ID,disk_reads / executions AS "Reads/Exec",disk_reads, executions

1. FROM V$SQLAREA

1. WHERE disk_reads > 1000

1. ORDER BY "Reads/Exec" DESC

1. )

1. WHERE rownum <= 10;