1.查看逻辑读前十的SQL
https://www.cndba.cn/hbhe0316/article/5036
https://www.cndba.cn/hbhe0316/article/5036
https://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;
https://www.cndba.cn/hbhe0316/article/5036https://www.cndba.cn/hbhe0316/article/5036
2.查看物理读前十的SQL
https://www.cndba.cn/hbhe0316/article/5036
https://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;
https://www.cndba.cn/hbhe0316/article/5036
https://www.cndba.cn/hbhe0316/article/5036
https://www.cndba.cn/hbhe0316/article/5036
版权声明:本文为博主原创文章,未经博主允许不得转载。
Linux,oracle