如何定位消耗资源sql语句

select b.username,a.buffer_gets--磁盘读取量,a.executions--执行时间,a.buffer_gets/decode(a.executions,0,1,a.executions)--单位读取数,a.sql_text--SQL语句 SQL from v$sqlarea a,dba_users b where a.parsing_user_id = b.user_id and a.buffer_gets>10000 order by buffer_gets desc;

 

 

可以把disk_reads 改成buffer_gets则求出消耗内存多的sql

 

另外可以做sql trace；awr等对sql进行定位