17,382
社区成员




select b.username username,
a.buffer_gets gets,
a.executions exec,
a.buffer_gets / decode(a.executions, 0, 1, a.executions) get_exec_ratio,
a.sql_text Statement
from v$sqlarea a, dba_users b
where a.parsing_user_id = b.user_id
order by a.buffer_gets desc;
楼主可以看下,http://blog.csdn.net/managergh/article/details/6914279