网络编程
位置：首页>> 网络编程>> 数据库>> Oracle查看逻辑读、物理读资源占用排行的SQL语句

Oracle查看逻辑读、物理读资源占用排行的SQL语句

作者：junjie　　发布时间：2023-06-25 23:53:53　

标签：Oracle,逻辑读,物理读,SQL语句

查看逻辑读前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;

0
投稿

猜你喜欢

手机版 网络编程 asp之家 www.aspxhome.com