Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    7

    Question Unanswered: How to handle this kind of exception

    I wrote a jdbc file and call some cursors many times. At some special time, it will give an exception like this:

    =============================================
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
    =============================================

    What does this mean? Do I need to close the cursor when I finished calling it? But How do I do close in the jdbc?

    Thank you!

  2. #2
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: How to handle this kind of exception

    Originally posted by harry_hurry
    I wrote a jdbc file and call some cursors many times. At some special time, it will give an exception like this:

    =============================================
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
    =============================================

    What does this mean? Do I need to close the cursor when I finished calling it? But How do I do close in the jdbc?

    Thank you!
    You are opening too much cursors: this is the problem.
    You have two solutions, or better a solution (1) and a workaround (2):
    1) close the cursors you are not using (YOU CANNOT USE SO MUCH CURSORS) so that the cursors of your sessions are enough;
    2) prepare the instance to treate the load you are putting on it,
    open_cursors = 500
    session_cached_cursors = 50

    If it doesn't work try (1000, 100) and then (1500,150) and finally you MUST try solution (1) you have ignored so far :-))

    Good luck!
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

Posting Permissions

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