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