
--查找bad sql的方法: select * from (select buffer_gets, sql_text from v$sqlarea where buffer_gets >500000 order by buffer_gets desc) where rownum<=30; -- 执行次数多的SQL select sql_text,executions from (select sql_text,executions from v$sqlarea order by executions desc) where rownum<81; -- 读硬盘多的SQL select sql_text,disk_reads from (select sql_text,disk_reads from v$sqlarea order by disk_reads desc) where rownum<21; -- 排序多的SQL select sql_text,sorts from (select sql_text,sorts from v$sqlarea order by sorts desc) where rownum<21;
同事写的,先放着