I am using Weblogic 10.3.4 + Oracle DB both on Solaris machines (VM)
Unfortunately last week our app hosted on Weblogic became very very slow not being able to serve new users coming (everything lasted for 1h).
In order to find out the cause is we asked reports from the OS level , DB level.
The reports shown:
- a very intesive CPU usage that hour. (clearly was a peak from number of users using the system)
- Connection Pool reached the top limit on Weblogic (200 connections !)
- AWR stats from Db shown a degradation in response times.
NOW who was first the chicken or the egg ?
A very slow DB can cause WEBlogic to be slow and to reach the max numeber of connections from pool.
However if the CPU is very used , it might be that the threads holding the DB connections to be so busy that they do not return the connection to the pool (because the processor is busy)==> a new client comes a new connection is assgined and so on ...so the connection pool might be exhausted as well in this way ...?