select
b.username username,a.buffer_gets buf_gets,
a.sql_text statement
from
v$sqlarea a,dba_users b
where
a.parsing_user_id = b.user_id and a.buffer_gets > 1000
order by
a.buffer_gets desc
buffer_gets ：会话中SQL语句的内存使用量；
