Re: Max open cursors

From: Patrice Castet <patrice.castet_at____nospaaaaam____in-fusio.com>
Date: Mon, 10 Mar 2003 13:31:11 GMT
Message-ID: <3e6c9348.622889546@read.news.fr.uu.net>

it can also occurs when you perform warm backups, cursors are open for each tablespace to be backuped.

On Mon, 10 Mar 2003 13:19:06 GMT, "David COSTE" <dco_at_compaq.com> wrote:

>Hello,
>
>I'm currently experiencing a problem with the "max open cursors" error.
>I looked into my PL/SQL code and the cursors are always closed just after
>being used.
>This is not the first time I see this problem and in both cases the package
>DBMS_SQL was intensively used.
>Has anyone already met this problem ?
>Is there a solution (except increasing the max open cursors parameter whch
>is already set to 600) ?
>Any info would be appreciated..
>
>Thanks in advance.
>David
>
>
>PS : for info, this problem is occuring on Oracle 9.2.0 for HPUX (64 bits)
>and I already met this kind of problem with Oracle 8.0.5 under windows NT
>
>
Received on Mon Mar 10 2003 - 07:31:11 CST