mysql 逻辑读 物理读_Oracle 查看 逻辑读、物理读 前10的SQL

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

https://www.cndba.cn/dave/article/1974https://www.cndba.cn/dave/article/1974https://www.cndba.cn/dave/article/1974

https://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：

https://www.cndba.cn/dave/article/1974https://www.cndba.cn/dave/article/1974

https://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;

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