Sorry for not being clear, I'm looking for the average server settings for the number of cursors allowed
On 6/20/05, Eddie <[EMAIL PROTECTED]> wrote: > On 6/20/05, Dustin Tinney <[EMAIL PROTECTED]> wrote: > > Current Setup: > > > > Dual Sun Station running Production Web server (CFMX 6.1) & DB Oracle > > 8i. Single CPU test station connected to the Live DB. > > > > My Question is this: > > We've recently started getting number of open cursors exceeded. I > > know that our Production Env. is set to have 100 Max Pooled > > Statements allowed to it. Our test Env. has it set to 50 Max Pooled > > Statements. I know that Max Pooled Statements are usually based upon > > your applications load but I'm trying to figure out what MOST web > > servers are run with in hopes of our IT dept increasing our Max > > Pooled Statements. > > > > Where is your question? I'm guessing is it is: How do I make the > Oracle database stop spitting out "ORA-01000: maximum open cursors > exceeded" errors? > > The answer would be to increase the number of maximum cursors per > session by setting the parameter OPEN_CURSORS in your init.ora file to > a higher number, like for example to 500 or more. > > HTH > -- > Eddie. > http://awads.net/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210017 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
