rac

select
ss.inst_id,
ss.username,
se.sid,
ss.program,
value/100 cpu_usage_seconds
from
gv$session ss,
gv$sesstat se,
gv$statname sn
where se.statistic#=sn.statistic#
and name like '%CPU used by this session%'
and se.sid=ss.sid

SET LINESIZE 200
COLUMN sid FORMAT 9999
COLUMN serial# FORMAT 9999999
COLUMN machine FORMAT A30
COLUMN progress_pct FORMAT 99999999.00
COLUMN elapsed FORMAT A10
COLUMN remaining FORMAT A10

SELECT s.inst_id,
       s.sid,

select w.event,count(9)
from gv$session s, gv$session_wait w
where s.sid=w.sid
group by w.event
order by 2;