Not sure of that Bob. Perhaps someone else on this mailing list could help you.
-----Original Message----- From: Phee, Martin J (Jump Tech) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:40 AM To: 'Turbine Users List' Subject: RE: DB Pooling and Processes Are you using Tomcat? You might need to restart it also. Also, make sure you release your connections back to turbine, and close any statements you are using. Are you using the OM? -----Original Message----- From: Bob Swerdlow [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 12:30 PM To: Turbine Users List Subject: Re: DB Pooling and Processes Thanks, Ian. I'll get the number of processes and connections into line. Any idea how can I get rid of all the old connections when I reload the project? Thanks, Bob ----- Original Message ----- From: "Ian Huynh" <[EMAIL PROTECTED]> To: "Turbine Users List" <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 1:12 PM Subject: RE: DB Pooling and Processes > Bob > I believe Oracle uses 1 process for each connection by default unless > you've set up Oracle to use the MTS dispatcher. > > And also by default 50 is the default max process for Oracle. > You can control this file by editing your INIT*.ORA file typically found > in %ORACLE_HOME%\<YourSID>\pfile\init*.ora and look for the > entry > > PROCESSES=100 > > BTW, you also need to restart your Oracle server to pick up the new value. > > Since connections are pooled (Don't know much about Turbine Pooling) but > in theory, if you app uses connection wisely, you shouldn't need too many 'physical' > connections. BUt that entirely depends on your concurrent load and length > of time a connection is used by a thread in your app. You need to load test your > app to find the right number. > > Also beware that Oracle also limits 300 open cursors by default. This > is another area where most people also run into trouble. You can > change this param in your init*.ora file as well. If you need a large > number of connections, chances are you probl. will run into this limit as well. > > open_cursors = 300 > > > > > -----Original Message----- > From: Bob Swerdlow [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 10:06 AM > To: [EMAIL PROTECTED] > Subject: DB Pooling and Processes > > > Hi, y'all - > > Is there documentation somewhere about how to set up Oracle with Turbine DB > Pooling? > > We ran into a problem recently where we were getting "cannot get connection" > errors. I found that our TurbineProperties.Resources had: > > # The number of database connections to cache per ConnectionPool > # instance (specified per database). > database.default.maxConnections=3 > > Since the failure happend when our code was setting up 4 connections, I knew > I had to change this. After a bit of web-snooping, I changed it to 100. > > Now we are getting this error: > ORA-00020: maximum number of processes (50) exceeded > > This actually happened after reloading the project a few times. > > So my questions are: > 1. What is an appropriate value for database.default.maxConnections? This > will be a public web site with many concurrent users retrieving pages that > will access the database > 2. Do I need to coordinate the number of connections with the number of > Oracle processes? How do I control this in Oracle? > 3. Should reloading the project release all of the connections? It does > not seem to have done so, however, when I restarted Tomcat, those processes > seemed to go away. > 4. What else should I worry about? > > Thanks for your help! > > Bob Swerdlow > Chief Operating Officer > Transpose, LLC > [EMAIL PROTECTED] > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
