Re: Max open cursors

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 10 Mar 2003 19:00:02 +0100
Message-ID: <njkp6v0i470r3vu48oipss7lfbu7hmf6id@4ax.com>

On Mon, 10 Mar 2003 14:47:11 GMT, "David COSTE" <dco_at_compaq.com> wrote:

>Actually, no warm backup is being performed when I had the problem.
>I have the feeling that Oracle does not immediately realease the opened
>cursor when you close them especailly when using DBMS_SQL.

pl/sql cursor are automatically closed, dbms_sql cursors are not. Your program probably is lacking in dbms_sql.close_cursor calls.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Mar 10 2003 - 12:00:02 CST