| 标题 | 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; |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。