Re: Max open cursors

Are you shure your cursors are closed after processing?

Chad Sheley <csheley_at_usa.capgemini.com> schreef in berichtnieuws XUVv4.597$3z4.21367_at_news.uswest.net...
> I'm wondering how far I can increase the OPEN_CURSORS parameter on my
Oracle
> 8.05 database until some different problem comes up besides "Max Open
> Cursors Exceeded"?
>
> I have a Java class that is reading some records from a file, doing some
> validation and then calling a series of stored procedures to insert the
data
> into 4 tables.
>
> I've had the same problem on other similar processes and just kept
> incrementing the OPEN_CURSORS parameter to the current setting of 5000.
>
> I'm not even real sure if 5000 is some incredibly excessive number!
>
> I should also mention that we've added COMMITs in the Java code at various
> places to try and circumvent the problem, to no avail. Am I missing
> something here too? I thought a COMMIT would release the cursor resources.
>
> Is there anything else to try for this situation, or should I just keepin
> incrementing OPEN_CURSORS?
>
> Chad Sheley
> Senior Consultant
> Cap Gemini
> Des Moines, IA
>
>
Received on Fri Mar 03 2000 - 22:21:42 CET