Results 1 to 3 of 3

Thread: Open Cursors

  1. #1
    Join Date
    Mar 2003
    Location
    Italy
    Posts
    17

    Unanswered: Open Cursors

    Hi!

    I'm getting an Open Cursor exeeded error while running our application.
    The server Oracle is 8.17 version, the o.s. is Linux. The C++ code is running some SQLs, using OCI. The queries don't use bind variables, but they are parsed and the values are substituted before they run on the Oracle server.
    I've seen the message recently posted by sunilthomas98, but the thread doesn't solve my problem: I never open explicit cursors, but every time I run a query I suppose Oracle open an implicit cursor. After a lot of operations, the number of open cursors go over the max value.
    Is there some way to make Oracle close those cursors?
    When I tried to run the same application on 9i Oracle version, I have no error, and the opend cursors are always a few.

    thanks,

    F.

  2. #2
    Join Date
    Sep 2003
    Posts
    16
    Check the max_open_cursors setting in the database. Could be too low.

  3. #3
    Join Date
    Mar 2003
    Location
    Italy
    Posts
    17
    Thanks, Paul.
    Unluckily, I've already incremented it, but the number of open cursors seems to grow without end! I'm searching for a way to stop this growth.



    Originally posted by PaulMcClure
    Check the max_open_cursors setting in the database. Could be too low.

Posting Permissions

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