top sessions por cpu en rac. | ExpoDBA

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
/