I still think you should look into JDBC drivers, when we addressed that it fixed the issue. The reason we even looked into it was because the Oracle admins here fight with every ounce they have against changing one setting in their environment. What we noticed is the issue did not happen in CF5 or CF7 but did on CF6.1 and this was all for the exact same application just being moved between servers.
On 6/21/05, Dustin Tinney <[EMAIL PROTECTED]> wrote: > > There should be at least lower and upper bounds for the cursor settings. > > Our IT staff refuses to up our limit from 100 feeling as though 100 > cursors is plenty to run any system. I realize that there maybe > systems that could run with 100 cursors however, with out evidence of > what others are running there is no possible way that they will up our > limits. They feel as though 100 is a high value and that if we go > beyond this, as we have recently, there is problems with in our > applications not with in the server configs. > > To answer the question before we have 0 triggers and 0 stored procs. > The only connections to the database are from our live and test > servers both using the JDBC Driver. We hit our cursor limit at least > 1 time a week if not a day. > > > > On 6/20/05, Dustin Tinney <[EMAIL PROTECTED]> wrote: > > 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/ > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210087 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
