Re: Open_Cursors

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Mon, 12 Apr 2004 23:14:58 +0200
Message-ID: <qi1m70hkkannf2s3hplcarhr4sam65mauj@4ax.com>

On 12 Apr 2004 13:04:13 -0700, rwest_at_paperthin.com (Ron West) wrote:

>We are working with an application built in CFMX (ColdFusion MX) and
>are seeing some oddities with "maximum open cursors exceeded". I have
>read a bit on this and seen settings as high as 2000.
>
>Can anyone explain to me the direct relationship between the
>Open_Cursors setting and memory. I.e. if you have 2000 Open_Cursors
>at any given time it will take up xx amount of memory.
>
>Unfortunatlely with ColdFusion we have no control over the releasing
>of Open_Cursors so I want to set this to a higher value.

open_cursors is a *session* parameter (so you can have 2000 cursors per *session*) and the memory is pre-allocated for all of your potential 2000 cursors.
I would recommend digging deeper into Coldfusion. Assertions like you posted above have all too often proved to be incorrect.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Apr 12 2004 - 16:14:58 CDT