Open_Cursors

From: Ron West <rwest_at_paperthin.com>
Date: 12 Apr 2004 13:04:13 -0700
Message-ID: <641efd59.0404121204.15745263@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. Received on Mon Apr 12 2004 - 15:04:13 CDT