Fusion Middleware Control Help for WebLogic Server

Previous Next Open TOC in new window
Content starts here

Clustered Application Deployment: Monitoring: Environment Monitoring

Column Display     

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.

Name Description
Server

The server on which the data source is deployed.

Active Connections Average Count

Average number of active connections in this instance of the data source.

Active connections are connections in use by an application. This value is only valid if the resource is configured to allow shrinking.

MBean Attribute:
JDBCDataSourceRuntimeMBean.ActiveConnectionsAverageCount

Active Connections Current Count

The number of connections currently in use by applications.

MBean Attribute:
JDBCDataSourceRuntimeMBean.ActiveConnectionsCurrentCount

Active Connections High Count

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:
JDBCDataSourceRuntimeMBean.ActiveConnectionsHighCount

Connection Delay Time

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:
JDBCDataSourceRuntimeMBean.ConnectionDelayTime

Connections Total Count

The cumulative total number of database connections created in this data source since the data source was deployed.

MBean Attribute:
JDBCDataSourceRuntimeMBean.ConnectionsTotalCount

Current Capacity

The current count of JDBC connections in the connection pool in the data source.

MBean Attribute:
JDBCDataSourceRuntimeMBean.CurrCapacity

Current Capacity High Count

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:
JDBCDataSourceRuntimeMBean.CurrCapacityHighCount

Enabled

Indicates whether the data source is enabled or disabled:

  • true

    if the data source is enabled.

  • false

    if the data source is disabled.

MBean Attribute:
JDBCDataSourceRuntimeMBean.Enabled

Failed Reserve Request Count

The cumulative, running count of requests for a connection from this data source that could not be fulfilled.

MBean Attribute:
JDBCDataSourceRuntimeMBean.FailedReserveRequestCount

Failures To Reconnect Count

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:
JDBCDataSourceRuntimeMBean.FailuresToReconnectCount

Highest Number Available

Highest number of database connections that were idle and available to be used by an application at any time in this instance of the data source since the data source was deployed.

MBean Attribute:
JDBCDataSourceRuntimeMBean.HighestNumAvailable

Leaked Connection Count

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 close().

MBean Attribute:
JDBCDataSourceRuntimeMBean.LeakedConnectionCount

Number Available

The number of database connections that are currently idle and available to be used by applications in this instance of the data source.

MBean Attribute:
JDBCDataSourceRuntimeMBean.NumAvailable

Number Unavailable

The number of connections currently in use by applications or being tested in this instance of the data source.

MBean Attribute:
JDBCDataSourceRuntimeMBean.NumUnavailable

Prep Stmt Cache Access Count

The cumulative, running count of the number of times that the statement cache was accessed.

MBean Attribute:
JDBCDataSourceRuntimeMBean.PrepStmtCacheAccessCount

Prep Stmt Cache Add Count

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:
JDBCDataSourceRuntimeMBean.PrepStmtCacheAddCount

Prep Stmt Cache Current Size

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:
JDBCDataSourceRuntimeMBean.PrepStmtCacheCurrentSize

Prep Stmt Cache Delete Count

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:
JDBCDataSourceRuntimeMBean.PrepStmtCacheDeleteCount

Prep Stmt Cache Hit Count

The cumulative, running count of the number of times that statements from the cache were used.

MBean Attribute:
JDBCDataSourceRuntimeMBean.PrepStmtCacheHitCount

Prep Stmt Cache Miss Count

The number of times that a statement request could not be satisfied with a statement from the cache.

MBean Attribute:
JDBCDataSourceRuntimeMBean.PrepStmtCacheMissCount

Reserve Request Count

The cumulative, running count of requests for a connection from this data source.

MBean Attribute:
JDBCDataSourceRuntimeMBean.ReserveRequestCount

State

The current state of the data source.

Possible states are:

  • Running

    - the data source is enabled (deployed and not Suspended). This is the normal state of the data source. This state includes conditions when the database server is not available and the data source is created (creation retry must be enabled) or when all connections have failed connection tests (on creation, on reserve, or periodic testing).

  • Suspended

    - the data source has been disabled.

  • Shutdown

    - the data source is shutdown and all database connections have been closed.

  • Overloaded

    - all resources in pool are in use.

  • Unknown

    - the data source state is unknown.

MBean Attribute:
JDBCDataSourceRuntimeMBean.State

Successful RCLB Based Borrow Count

The number of reserve requests for which existing connections were found that satisfied the runtime connection load balancing policy.

MBean Attribute:
JDBCOracleDataSourceRuntimeMBean.SuccessfulRCLBBasedBorrowCount

Failed RCLB Based Borrow Count

The number of reserve requests for which a connection was not found based on the runtime connection load balancing policy.

MBean Attribute:
JDBCOracleDataSourceRuntimeMBean.FailedRCLBBasedBorrowCount

Successful Affinity Based Borrow Count

The number of reserve requests for which an existing connection was found that satisfied the affinity policy.

MBean Attribute:
JDBCOracleDataSourceRuntimeMBean.SuccessfulAffinityBasedBorrowCount

Failed Affinity Based Borrow Count

The number of reserve requests for which an existing connection for the affinity policy was not found.

MBean Attribute:
JDBCOracleDataSourceRuntimeMBean.FailedAffinityBasedBorrowCount

JDBC Driver

The driver class name of the JDBC driver used to create database connections.

MBean Attribute:
JDBCDataSourceRuntimeMBean.VersionJDBCDriver

Wait Seconds High Count

The highest number of seconds that an application waited for a connection (the longest connection reserve wait time) from this instance of the connection pool since the connection pool was instantiated.

This value is updated when a completed getConnection request takes longer to return a connection than any previous request.

MBean Attribute:
JDBCDataSourceRuntimeMBean.WaitSecondsHighCount

Waiting For Connection Current Count

The number of connection requests waiting for a database connection.

MBean Attribute:
JDBCDataSourceRuntimeMBean.WaitingForConnectionCurrentCount

Waiting For Connection Failure Total

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:
JDBCDataSourceRuntimeMBean.WaitingForConnectionFailureTotal

Waiting For Connection High Count

Highest number of application requests concurrently waiting for a connection from this instance of the data source.

MBean Attribute:
JDBCDataSourceRuntimeMBean.WaitingForConnectionHighCount

Waiting For Connection Success Total

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:
JDBCDataSourceRuntimeMBean.WaitingForConnectionSuccessTotal

Waiting For Connection Total

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:
JDBCDataSourceRuntimeMBean.WaitingForConnectionTotal


Back to Top