1、按物理读 读取磁盘次数
select s.SQL_FULLTEXT,s.DISK_READS/s.EXECUTIONS from v$sqlarea s where s.EXECUTIONS >0 and s.DISK_READS >1000
order by s.DISK_READS/s.EXECUTIONS desc
2.、按内存消耗
select s.SQL_FULLTEXT,s.BUFFER_GETS/s.EXECUTIONS from v$sqlarea s where s.EXECUTIONS >0 and s.BUFFER_GETS >1000
order by s.DISK_READS/s.EXECUTIONS desc