cpu

col statement format a30 wrap
col username format a10 trunc
select b.sql_text \"Statement \",a.buffer_gets \"BUffer Gets\",
a.executions \"Executions\",
a.buffer_gets/decode(a.executions,0,1,a.executions) \"Ratio\",
c.username from v$sqlarea a,
v$sqltext_with_newlines b,
dba_users c
where a.parsing_user_id = c.user_id
and a.address=b.address
and a.buffer_gets>1
order by a.buffer_gets desc,b.piece;