On Thu, Sep 9, 2010 at 8:57 AM, sasidhar prabhakar
<sasidhar1229@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
|