查看邏輯讀前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;
更多信息請查看IT技術專欄
公眾號
事業(yè)單位
當前位置：
公考類
招聘類
各類考試