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.
|
