Re: Closing PL/SQL cursor

Well, I think CLOSE_CACHED_OPEN_CURSORS is the solution.

Each time user connect to my application, it querys preferences and configuration parameters. A lot of cursors are opened at this time for a really short time but are not used later in the session. A end of initialization, the application updates registration tables and ... commit. So, if I set CLOSE_CACHED_OPEN_CURSORS to True, any cached cursor should be closed. :-)

Thanks.

    Yann.

> see the init.ora parameter close_cached_open_cursors. set it to true. on
> commit, it'll close these cached cursors (but performance will be affected on
> subsequent executes).
>
> setting max cursors to 500 or so might be a better solution..
>
> >As I use many functions, database fails out of cursors if users don't
> >disconnect and reconnect several times in a day (that's the only way I
> >found to flush unused cursors !)
> >
> >PLEASE HELP !!!!!! I need someone explain me how it works ...
> >
> >Configuration:
> > ServeurNT, Oracle 7.3.2
> > OPEN_CURSORS = 110 (Never so much useful at a time)
> >
>
> --
> See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Tue Sep 28 1999 - 11:22:43 CEST