日期:2014-05-16 浏览次数:20938 次
----按 disk_reads 的次数找 topsql信息
SELECT b.username username,a.sql_id, a.executions exec, a.buffer_gets buffer, a.disk_reads disk,
a.parse_calls parse,a.sql_text statement
FROM V$SQLAREA a, dba_users b
WHERE a.parsing_user_id=b.user_id and ( a.buffer_gets > 10000000 OR a.disk_reads > 1000000 )
ORDER BY a.buffer_gets + 100 * a.disk_reads DESC;