Re: Out of cursors / Error on recursion lvl1 in Sql*Plus...

Hi!

The limit 50 says that there can not be more than 50 cursors open concurrently by one session.
It has to do with the fact that there is more than 50 SELECT's having their resultset in the memory. If the the errors happen on a "simple select", it is because it creates the 51th open cursor. It sounds to me that the error will occur, for you, rather randomly, based on the use of the database that day/due to different use by the users.

Frank

Andreas Koch <mail_at_kochandreas.com> wrote in message news:3B7D88A4.AE891109_at_kochandreas.com...
>
>
> Sybrand Bakker schrieb:
>
> > Increase the init.ora parameter open_cursors (and bounce the database)
> > The default is 50 which is clearly ridiculous
> > If you are using default parameters there is *much more* you need to
change.
> > The defaults remained unaltered since 1989
> > Also never use Oracle without reading any manual.
> > Reinstalling to resolve such an easy problem, what should I say?
>
> Well... we usually install it with default paremeters, and usually
> don't get "too many open cursors" on a single, simple select.
>
> So i basically don't understand why the open_cursors setting should
> be the real problem here....50 seem to be sufficent for
> a few users fully working with our apps, so why won't it be enough
> for a single select in other cases?
>
> --
> Andreas
> Mach's mit /-\
> |o|
> \-/ gib KIDS keine Chance! ;-)
Received on Sat Aug 18 2001 - 01:56:34 CDT