Re: OPEN_CURSORS is getting out of hand!
Date: Wed, 30 Nov 1994 20:06:48
Message-ID: <daren.61.00141DA3_at_morgan.ucs.mun.ca>
In article <30NOV94.19241599_at_nauvax.ucc.nau.edu> kkc_at_nauvax.ucc.nau.edu writes:
>From: kkc_at_nauvax.ucc.nau.edu
>Subject: OPEN_CURSORS is getting out of hand!
>Date: Wed, 30 Nov 1994 19:24:15 GMT
>Hello all you Oracle geniuses!!
>Recently, our users have been getting ORACLE errors in their application
>that indicate "max cursors exceeded" "error at recursive SQL level 1".
>In the last two weeks, I have had to increase the OPEN_CURSORS variable
>in the init.ora 3 times. Each time it seemed as though the problem was
>solved, but a few days later it hits us again. There is not much
>documentation on this variable, but it does say that its value is
>unlimited which tells me I can boost it as much as I want?? But my question
>is what is causing it all of the sudden, and if I keep boosting it
>up, will it degrade the system's performance?? Its current value is
>now 200 which seems outrageous to me, but what is the average size
>of this variable for large (2 G) databases??
We had to bump ours to 254. It is really not the the size of the database that is the determining factor but the complexity of the application. In our case it was a forms3 app which opens many cursors. In some cases even if you only issue a select statement with one row returned. At least that's what my memory is telling me today. Please correct me!
Daren Janes (709)729-7540
daren_at_morgan.ucs.mun.ca
Systems Programmer
NewTel Information Solutions Ltd.
===> Any Opinons expressed in this message are mine, NOT MY EMPLOYERS <=== Received on Wed Nov 30 1994 - 20:06:48 CET