DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2001
    My users are getting Max Open Cursors Exceeded error.

    I went through all the stored procedures and made sure that all the cursors are closed properly.

    I queried v$open_cursor, as "select sqltext from v$open_cursor"
    It not only gave the cursors in the stored procedure I just executed, but also some other sql statements present in the stored procedure.

    Does it mean that each sql statement in the stored procedure corresponds to a cursor ? How can we close them then ?

    Then I searched this forum, and in one of the earlier threads, it was discussed that this view will give even the sqls that were parsed, hence the number is not accurate.

    What contributes to the total cursors present ? Is it the value in v$open_cursors ? If so, how can we flush these sql statements off so that the total number of open cursors remains low ?

    Please help

  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    Check this thread on how to deal with the open cursor problems. I'v posted on the relationsships and the limits on this.

    You need to bump the OPEN_CURSOR parameter to solve the problem. Then you have to make sure that your applications are closing the cursors promptly. Then you can set the profile on user connections that would be removed if they were to be idle. These are some of the ways to remove the sessions, which inturn remove the cursors.


    Life is a journey, not a destination!

  3. #3
    Join Date
    Nov 2000
    increase the value of open_cursor in init.ora file

    from Anuj

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.