查看逻辑读前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;
本文地址:https://www.stayed.cn/item/3137
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我