ORACLE Script para verificar número de cursores abertos

1
2
3
4
5
6

select o.sid, osuser, machine, count(*) num_curs
from v$open_cursor o, v$session s
where o.sid=s.sid
and osuser like '[usuario]'
group by o.sid, osuser, machine
order by num_curs;

select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where o.sid=s.sid and osuser like '[usuario]' group by o.sid, osuser, machine order by num_curs;