Re: ORA-01000 - maximum open cursors exceeded

Parris Geiser wrote:
>
> Chuck Hamilton (chuckh_at_ix.netcom.com) wrote:
> > I receive this error from time to time and am not sure what's causing
> > it. I tried increasing the default setting from 50 to 100 for the open
> > cursors parameter but it still happens, though less frequently.
 

> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-01000: maximum open cursors exceeded
 

> > What's causing it and how do I eliminate it?
 

> > If a user breaks a query, or if a session get's killed while it's
> > running a query; will that leave cursors open indefinitely?

You didn't mention what applications you are running, but somewhere in the Oracle Forms documentation it mentions that Forms will open 5 cursors for each *block* associated with a table (1 each for insert, update, select, delete, and something else). So depending on your forms and usage, you can run out of cursors quickly.

Most of the lit I've read recommends simply setting OPEN_CURSORS to 255 (the max value) and leaving it. That's what I ended up doing, without deleterious effects.

Matthew M. Lih
Software Lead, SAIN Project
TRW Enterprise Solutions Received on Thu Feb 08 1996 - 00:00:00 CET