客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
|
查看逻辑读前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; |
请发表评论