Database Informations cpu usage

spool D:\cpu.txt

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;

spool off;

* Please test this script before use. Author will not be responsible for any damage that may be cause by this script.