摘要:
Top 10 by Buffer Gets:set linesize 100set pagesize 100SELECT * FROM(SELECT substr(sql_text,1,40) sql, buffer_gets, executions, buffer_gets/executions "Gets/Exec", hash_value,addressFROM V$SQLAREA WHERE buffer_gets > 10000ORDER BY buffer_gets DESC)WHERE rownum <= 10;Top 10 by Physical 阅读全文
posted @ 2012-08-16 17:55 徐正柱- 阅读(800) 评论(0) 推荐(0) 编辑