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

[Tarry]

This will give you how many cursors are opened currently..

SQL> select name, value from v$sysstat
  2  where name='opened cursors current';

NAME                                                                  VALUE
---------------------------------------------------------------- ----------
opened cursors current                                                   11

cheers!!