Our webloc is installed on solaris. I think it's 10.xx. We have 8 application servers on 4 machines and this happens randomly on any of them. We have not identified patterns yet. The strange thing found when we investigate is when we look at the sessions from oracle toad for that overloaded machine, we see only inactive sessions. In admin console , we see 20 active connections and overloaded status for jdbc connection pool. The app server won't be able to get any connections and throws PoolLimitSQLException. In weblogic we set Inactive Connection Timeout = 15 seconds. We wonder why weblogic is not releasing connections even though they are inactive when we see from toad ? Any help would be appreciated. Thanks
We have these three enabled from admin console.
Test Connections On Reserve
Remove Infected Connections Enabled
Profile Connection Leak
- I am not sure where this will write to though.
- The application server log shows no messages on leaks