top sessions por cpu en rac.
top sessions por cpu en 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 and ss.status='ACTIVE' and ss.username is not null order by value /