Re: Open_Cursors

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 13 Apr 2004 00:34:57 GMT
Message-ID: <RAGec.42598$e17.26431@twister.nyroc.rr.com>

"Ron West" <rwest_at_paperthin.com> wrote in message news:641efd59.0404121204.15745263_at_posting.google.com...
> 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.

I would second Sybrand's comment ..
I have worked with cold Fusion in the past and never ever came across any open_cursors oddity that you state.
You might want to clarify that comment and/or recheck the cause of the error.

Anurag Received on Mon Apr 12 2004 - 19:34:57 CDT