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

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! ;-)