Hoe to find, How many no. of CURSORS opened in a session ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Apr 2002
    Posts
    2

    Thumbs up How many no.of CURSORS opened in a session

    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

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width