Verificar número de cursores abertos
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;
Compartilhando Conhecimento
Verificar número de cursores abertos
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;