JDBC Data Source: Monitoring: Statistics

àì夳堔傛蜴生んèń 2023-10-18 20:55 86阅读 0赞

## JDBC Data Source: Monitoring: Statistics ##

[Column Display][] [Related Tasks][] [Related Topics][]

This page displays statistics associated with this JDBC data source. Use this page to monitor the activity of the data source.

Column Display

You can show fewer or additional data points on this page by expanding **Customize this table** and modifying the **Column Display** list. Each data point displays in its own table column.

The following table lists all of the data points that you can display in columns on this page.

<table> 
 <thead> 
 <tr> 
 <th>Name</th> 
 <th>Description</th> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Name</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The name of this configuration. WebLogic Server uses an MBean to implement and persist the configuration. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#Name" rel="nofollow">JDBCDataSourceRuntimeMBean.Name</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Server</a></td> 
 <td style="vertical-align:top;"> The server on which the data source is deployed. </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Active Connections Average Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> Average number of active connections in this instance of the data source. Active connections are connections in use by an application. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#ActiveConnectionsAverageCount" rel="nofollow">JDBCDataSourceRuntimeMBean.ActiveConnectionsAverageCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Active Connections Current Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The number of connections currently in use by applications. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#ActiveConnectionsCurrentCount" rel="nofollow">JDBCDataSourceRuntimeMBean.ActiveConnectionsCurrentCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Active Connections High Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> Highest number of active database connections in this instance of the data source since the data source was instantiated. Active connections are connections in use by an application. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#ActiveConnectionsHighCount" rel="nofollow">JDBCDataSourceRuntimeMBean.ActiveConnectionsHighCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Connection Delay Time</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The average amount of time, in milliseconds, that it takes to create a physical connection to the database. The value is calculated as summary of all times to connect divided by the total number of connections. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#ConnectionDelayTime" rel="nofollow">JDBCDataSourceRuntimeMBean.ConnectionDelayTime</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Connections Total Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative total number of database connections created in this data source since the data source was deployed. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#ConnectionsTotalCount" rel="nofollow">JDBCDataSourceRuntimeMBean.ConnectionsTotalCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Current Capacity</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The current count of JDBC connections in the connection pool in the data source. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#CurrCapacity" rel="nofollow">JDBCDataSourceRuntimeMBean.CurrCapacity</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Curr Capacity High Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> Highest number of database connections available or in use (current capacity) in this instance of the data source since the data source was deployed. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#CurrCapacityHighCount" rel="nofollow">JDBCDataSourceRuntimeMBean.CurrCapacityHighCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Enabled</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> Indicates whether the data source is enabled or disabled: 
 <ul> 
 <li><code>true</code> if the data source is enabled. </li> 
 <li><code>false</code> if the data source is disabled. </li> 
 </ul>MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#Enabled" rel="nofollow">JDBCDataSourceRuntimeMBean.Enabled</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Failed Reserve Request Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative, running count of requests for a connection from this data source that could not be fulfilled. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#FailedReserveRequestCount" rel="nofollow">JDBCDataSourceRuntimeMBean.FailedReserveRequestCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Failures To Reconnect Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The number of times that the data source attempted to refresh a database connection and failed. Failures may occur when the database is unavailable or when the network connection to the database is interrupted. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#FailuresToReconnectCount" rel="nofollow">JDBCDataSourceRuntimeMBean.FailuresToReconnectCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Highest Num Available</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> Highest number of database connections that were available at any time in this instance of the data source since the data source was deployed. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#HighestNumAvailable" rel="nofollow">JDBCDataSourceRuntimeMBean.HighestNumAvailable</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Leaked Connection Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The number of leaked connections. A leaked connection is a connection that was reserved from the data source but was not returned to the data source by calling&nbsp;<code>close()</code>. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#LeakedConnectionCount" rel="nofollow">JDBCDataSourceRuntimeMBean.LeakedConnectionCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Num Available</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The number of database connections currently available (not in use) in this data source. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#NumAvailable" rel="nofollow">JDBCDataSourceRuntimeMBean.NumAvailable</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Num Unavailable</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The number of database connections that are currently unavailable (in use or being tested by the system) in this instance of the data source. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#NumUnavailable" rel="nofollow">JDBCDataSourceRuntimeMBean.NumUnavailable</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">PrepStmt Cache Access Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative, running count of the number of times that the statement cache was accessed. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#PrepStmtCacheAccessCount" rel="nofollow">JDBCDataSourceRuntimeMBean.PrepStmtCacheAccessCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Prep Stmt Cache Add Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative, running count of the number of statements added to the statement cache. Each connection in the connection pool has its own cache of statements. This number is the sum of the number of statements added to the caches for all connections in the connection pool. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#PrepStmtCacheAddCount" rel="nofollow">JDBCDataSourceRuntimeMBean.PrepStmtCacheAddCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Prep Stmt Cache Current Size</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The number of prepared and callable statements currently cached in the statement cache. Each connection in the connection pool has its own cache of statements. This number is the sum of the number of statements in the caches for all connections in the connection pool. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#PrepStmtCacheCurrentSize" rel="nofollow">JDBCDataSourceRuntimeMBean.PrepStmtCacheCurrentSize</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Prep Stmt Cache Delete Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative, running count of statements discarded from the cache. Each connection in the connection pool has its own cache of statements. This number is the sum of the number of statements that were discarded from the caches for all connections in the connection pool. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#PrepStmtCacheDeleteCount" rel="nofollow">JDBCDataSourceRuntimeMBean.PrepStmtCacheDeleteCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Prep Stmt Cache Hit Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative, running count of the number of times that statements from the cache were used. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#PrepStmtCacheHitCount" rel="nofollow">JDBCDataSourceRuntimeMBean.PrepStmtCacheHitCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Prep Stmt Cache Miss Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The number of times that a statement request could not be satisfied with a statement from the cache. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#PrepStmtCacheMissCount" rel="nofollow">JDBCDataSourceRuntimeMBean.PrepStmtCacheMissCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Reserve Request Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative, running count of requests for a connection from this data source. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#ReserveRequestCount" rel="nofollow">JDBCDataSourceRuntimeMBean.ReserveRequestCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">State</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The current state of the data source. Possible states are: 
 <ul> 
 <li><code>Running</code> - the data source is enabled (deployed and not&nbsp;<code>Suspended</code>). This is the normal state of the data source. </li> 
 <li><code>Suspended</code> - the data source has been manually disabled. </li> 
 <li><code>Shutdown</code> - the data source is shutdown and all database connections have been closed. </li> 
 <li><code>Overloaded</code> - all resources in pool are in use. </li> 
 <li><code>Unhealthy</code> - all connections are unavailable (not because they are in use). This state occurs if the database server is unavailable when the data source is created (creation retry must be enabled) or if all connections have failed connection tests (on creation, on reserve, or periodic testing). </li> 
 <li><code>Unknown</code> - the data source state is unknown. </li> 
 </ul>MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#State" rel="nofollow">JDBCDataSourceRuntimeMBean.State</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">JDBC Driver</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The driver class name of the JDBC driver used to create database connections. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#VersionJDBCDriver" rel="nofollow">JDBCDataSourceRuntimeMBean.VersionJDBCDriver</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Wait Seconds High Count</a></td> 
 <td style="vertical-align:top;"> The cumulative total number of database connections created in this data source since the data source was deployed. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#ConnectionsTotalCount" rel="nofollow">JDBCDataSourceRuntimeMBean.ConnectionsTotalCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Waiting For Connection Current Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The number of connection requests waiting for a database connection. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#WaitingForConnectionCurrentCount" rel="nofollow">JDBCDataSourceRuntimeMBean.WaitingForConnectionCurrentCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Waiting For Connection Failure Total</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative, running count of requests for a connection from this data source that had to wait before getting a connection and eventually failed to get a connection. Waiting connection requests can fail for a variety of reasons, including waiting for longer than the ConnectionReserveTimeoutSeconds. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#WaitingForConnectionFailureTotal" rel="nofollow">JDBCDataSourceRuntimeMBean.WaitingForConnectionFailureTotal</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Waiting For Connection High Count</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> Highest number of application requests concurrently waiting for a connection from this instance of the data source. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#WaitingForConnectionHighCount" rel="nofollow">JDBCDataSourceRuntimeMBean.WaitingForConnectionHighCount</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Waiting For Connection Success Total</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative, running count of requests for a connection from this data source that had to wait before getting a connection and eventually succeeded in getting a connection. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#WaitingForConnectionSuccessTotal" rel="nofollow">JDBCDataSourceRuntimeMBean.WaitingForConnectionSuccessTotal</a></code> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;"><a rel="nofollow">Waiting For Connection Total</a></td> 
 <td style="vertical-align:top;"><a rel="nofollow"></a><a rel="nofollow"></a> The cumulative, running count of requests for a connection from this data source that had to wait before getting a connection, including those that eventually got a connection and those that did not get a connection. MBean Attribute:&nbsp; <code><a href="https://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/mbeans/JDBCDataSourceRuntimeMBean.html#WaitingForConnectionTotal" rel="nofollow">JDBCDataSourceRuntimeMBean.WaitingForConnectionTotal</a></code> </td> 
 </tr> 
 </tbody> 
</table>

[Column Display]: https://docs.oracle.com/cd/E13222_01/wls/docs100/ConsoleHelp/pagehelp/JDBCjdbcdatasourcesjdbcdatasourcemonitorstatisticstitle.html#table
[Related Tasks]: https://docs.oracle.com/cd/E13222_01/wls/docs100/ConsoleHelp/pagehelp/JDBCjdbcdatasourcesjdbcdatasourcemonitorstatisticstitle.html#tasks
[Related Topics]: https://docs.oracle.com/cd/E13222_01/wls/docs100/ConsoleHelp/pagehelp/JDBCjdbcdatasourcesjdbcdatasourcemonitorstatisticstitle.html#concepts