The Connection Caches and Managed Connection Factory folders show statistics for cached database connections. You can display statistics for all caches or connection factories, or for each one individually. Table 11-2 describes the counters that display.
Counter name |
Description |
|---|---|
Connections open |
Snapshot count of open (but not necessarily active) connections. |
Connections active |
Snapshot count of active connections. |
Connections opened |
Cumulative count of the number of connections opened since the server started. |
Connections closed |
Cumulative count of connections closed since the server started. |
Waited connection requests |
Cumulative count of connection requests that required a wait because the maximum number of connections were in use. If this number is large, consider increasing the connection pool size. |
No wait connection requests |
Cumulative count of connection requests that required no wait. |
Forced connection requests |
Cumulative count of forced connection requests, that is, connections that were in excess of the configured pool size, but allocated immediately. If this number is large, consider increasing the connection pool size. |
Total connection requests |
Cumulative count of the total number of connection requests since the server started. |
Last maximum connections active |
Maximum count of active connections since starting the counter view. |
Peak maximum connections active |
Maximum count of active connections since the server started. |
