查看邏輯讀前10的SQL:
復(fù)制代碼 代碼如下:
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:
復(fù)制代碼 代碼如下:
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;
您可能感興趣的文章:- oracle中通配符和運(yùn)算符的使用方法介紹
- oracle邏輯結(jié)構(gòu)分析
- Oracle Arraysize設(shè)置對(duì)于邏輯讀的影響實(shí)例分析
- Oracle數(shù)據(jù)庫(kù)邏輯備份的SH文件
- oracle邏輯運(yùn)算符與其優(yōu)先級(jí)簡(jiǎn)介