查看邏輯讀前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;

總結(jié)

以上是生活随笔為你收集整理的查看mysql SQL物理读_Oracle查看逻辑读、物理读资源占用排行的SQL语句的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。