mercoledì 20 gennaio 2010

Oracle counting opened cursor

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.


Nessun commento:

Posta un commento