On Thu, Sep 9, 2010 at 8:57 AM, sasidhar prabhakar <sasidhar1...@gmail.com> wrote: > My application sometimes responding very slow. > When I observed the logs, it is showing these lines > > Cannot get a connection, pool error Timeout waiting for idle object. > > The maximum connections on oracle I set 150. > When I query for present sessions or process it is showing 70 to 80 and > decreasing to minimum of > 52, sometimes it grows up to 100 above also and it decreasing back to > minimum. > > In tomcat I configured max threads 300. > > context.xml is > > <Context path="" reloadable="true"> > <Resource > accessToUnderlyingConnectionAllowed="true" > auth="Container" > driverClassName="oracle.jdbc.OracleDriver" > maxActive="200" > maxIdle="10" > maxWait="8000" > validationQuery="SELECT * from dual" > testOnBorrow="true" > removeAbandoned="true" > removeAbandonedTimeout="30" > logAbandoned="true" > name="jdbc/ds" > password="" > type="javax.sql.DataSource" > url="" > username=""/> > <Resource auth="Container" name="mail/Session" type="javax.mail.Session" > mail.smtp.host="localhost"/> > > </Context> > > For few days I am getting this problem. >
More than likely a problem with your Oracle. When you can't get the sessions are you able to get them through another means such as toad or SQLDeveloper. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org