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;