asked on

weblogic JDBC connection monitoring

Does anyone have a suggestion on how to monitor a JDBC connection (Available connections) and create an alert in nagios or just a way to graph the number of connections.

I have a JDBC connection with 50 max connections and want to monitor how many connection are in use over a period of time.

for_yan

read these about monitoring connectyions in WebLogic JDBC connection pool:

http://docs.oracle.com/cd/E13222_01/wls/docs81/ConsoleHelp/domain_jdbcconnectionpool_monitor.html#1104829

http://docs.oracle.com/cd/E13222_01/wls/docs81/ConsoleHelp/jdbc_connection_pools.html#1106016

for_yan

this is for Weblogic 10 which has better tools to monitor JDBC connections:
http://docs.oracle.com/cd/E15051_01/wls/docs103/jdbc_admin/monitor.html

for_yan

I guess this is the useful table if you want to determine
the number of active connections in the pool programmatically:

http://docs.oracle.com/cd/E13222_01/wls/docs100/ConsoleHelp/pagehelp/JDBCjdbcdatasourcesjdbcdatasourcemonitorstatisticstitle.html

for_yan

check also this with some commands examples:

Monitoring JDBC Datasource Runtime Attributes using Weblogic Scripting Tool:

http://weblogic-wonders.com/weblogic/2011/01/15/monitoring-jdbc-datasource-runtime-attributes-using-wlst/

ASKER CERTIFIED SOLUTION

Sharon Seth

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial