Hi,

Where can I find how many cursors are currently opened.

I tried with following query, will it give accurate result ?

select count(*) from v$open_cursor;
COUNT(*)
----------
51
1 row selected.

My init.ora shows Open_cursors = 150 , but I am getting error that open cursor exceed .

V$sysstat shows :

select value from v$sysstat where statistic# = 3;
VALUE
----------
200
1 row selected.

which one is correct ?

Rgds,
gv.