Re: Help with cursor error
Date: 1995/05/23
Message-ID: <3psp7v$j67_at_linus.mitre.org>#1/1
Federico,
The problem is not related to your SGA nor a shortage of OPEN_CURSORS.
What is probably happening is you are closing a cursor prematurely and or
cursor that you are opening is encountering an error that you are not
addressing, which is causing the cursor to never be created or opened.
None the less this is a program bug. You need to look at the code.
Mike H.
: Hello all:
: I was wondering if there was some kind soul on the net who could offer
: some insight into a frustrating problem. We recently set up the Oracle
: 7.1.4 server on an SGI unix platform and migrated our database from a
: VAX platform. Oracle itself seems to be working fine. The problem arises
: when we use Oracle with another software package that makes calls to it.
: After a few queries with this software package, we get the error:
: This is followed by a slew of cursor related error messages.
: I've increased Oracle's SGA to about 50MB (we have 256MB of RAM) and
: set the OPEN_CURSORS init variable to 500. Is this truly a problem
: of running out of cursor space and if so how do I fix it?
: Thanks in advance for your help.
: - Federico Cabanes
Received on Tue May 23 1995 - 00:00:00 CEST