To find CPU Usage

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;