This oracle sql statement count cursor opened by session
select sid, count(*) from V$OPEN_CURSOR group by sid having count(*) > 40 ORDER BY count(*) desc;
The result :
Is used to monitoring ORA-01000 Maximum cursor exceeded.
mercoledì 20 gennaio 2010
Iscriviti a:
Commenti sul post (Atom)
Nessun commento:
Posta un commento