Chapter 11: Runtime Monitoring

Monitoring connection caches and managed connection factories

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.

**Table 11-2: Connection cache and managed connection factory statistics**
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.

View this book as PDF