To check Top CPU Session in last 5 minutes


Select
session_id,
count(*)
from
v$active_session_history
where
session_state=
‘ON CPU’ and
SAMPLE_TIME
> sysdate – (120/(24*60)) and rownum<11
group
by session_id
order
by
count(*)
desc;
Recent Posts