How to monitor OracleDB ACTIVE/INACTIVE Sessions on WebLogic?

WebLogic contains lots of inbox JDBC MBeans to monitor DB transactions. The most important ones are;

ActiveConnectionsCurrentCount@JDBCDataSourceRuntimeMBean

ActiveConnectionsAverageCount@JDBCDataSourceRuntimeMBean

WaitingForConnectionCurrentCount@JDBCDataSourceRuntimeMBean

ConnectionDelayTime@JDBCDataSourceRuntimeMBean

FailedReserveRequestCount@JDBCDataSourceRuntimeMBean

LeakedConnectionCount@JDBCDataSourceRuntimeMBean

These are available on Data Sources dashboard on WLSDM console.

If you are good at Database Administration or want to work close with DBA; Here is a recipe to reflect your DB knowledge to WLSDM dashboards and understand what’s going on at your main DB that WebLogic connects over JDBC driver.

Case: Monitoring ACTIVE/INACTIVE Oracle Database Sessions on WebLogic?

http://blog.wlsdm.com/how-to-monitor-oracledb-active-inactive-sessions-on-weblogic/