Re: Sporadic ORA-04030

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Fri, 21 Jan 2005 20:41:31 +0100
Message-ID: <bkm2v0dkbqfe4gcsio581k0379keujd9hb@4ax.com>

On Fri, 21 Jan 2005 08:12:11 -0600, Ed Stevens <nospam_at_noway.nohow> wrote:

>The second suggestion is to address the application. Am I wrong in
>thinking an app that holds this many open cursors is a problem? I've
>never had cause to look at this before and don't have a feel for what
>is "good" vs. "excessive."

60 cursors is not excessive. I would put the limit at 500. Do you use the session_cached_cursors parameter?

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jan 21 2005 - 13:41:31 CST