| 标题 | 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; |
| 随便看 |
|
在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板，是学习及工作的有利工具。