Hoe to find, How many no. of CURSORS opened in a session ?

[ColdBlood]

Hi All,
Is there any possibility to find How many CURSORS opened in a current Session.
My Actual problem is, When am accessing Oracle from my Application, it's throwing Exceptions like, "Maximum number of Cursors Exceeded..! " like.
There is one solution that, I can increase CURSOR attributes in Oracle Property file. But, I need to keep the value same.


If I know the count of Opened Cursors then, I'll restrict my PL/SQL sps to not execute,and so that, could not open cursors further.....
Plz mail me if you have any Idea about this.

Get back to me, If you need clarity on the Question.
This problem to rectified urgently..

Thanks.
Chandra

[Shestakov]

select n.name, m.value
from v$mystat m, v$statname n
where m.statistic# = n.statistic#
and n.name = 'opened cursors current';

-----------------------------------------------
If u going to use v$sysstat u will get number of opened cursors
in instance not in session. (as Tarry posted)
this value doesn't say nothing about limit:

"maximum cursors opened"

this limit reflect only session state (not instance).

[Edited by Shestakov on 06-14-2002 at 12:06 PM]