查看逻辑读前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;
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;
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;
需要了解更多数据库技术:Oracle查看逻辑读、物理读资源占用排行的SQL语句,都可以关注数据库技术分享栏目—计算机技术网(www.ctvol.com)!
本文来自网络收集,不代表计算机技术网立场,如涉及侵权请联系管理员删除。
ctvol管理联系方式QQ:251552304
本文章地址:https://www.ctvol.com/dtteaching/803595.html