Monitoring Oracle Weblogic Datasources

After you have created and deployed a JDBC Data Source, you can monitor it in the Weblogic Administration Console and check that it is working correctly.

 

Monitoring a Weblogic Data Source

This option is available by selecting your Data Source and clicking on Monitoring| Statistic sub tab. Statistics are displayed for each deployed instance of the Data Source. By default, the available columns just include the driver name and if the Data Source is enabled or not on a specific target. Choose the Customize tab to change the columns displayed in the Statistics table. For example, some of the available columns you should include are:

  • Active Connections Current Count: The number of connections currently in use by applications.
  • Active Connections Average Count: The average number of active connections from the time that the Data Source was deployed.
  • Connections Total Count: The cumulative total number of database connections created in this Data Source since it was deployed.
  • Current Capacity: The current count of JDBC connections in the connection pool in the Data Source.
  • Highest Num Available: The highest number of database connections that were available at any time in this instance of the Data Source since it was deployed.
  • Waiting for Connection High Count: The highest number of application requests concurrently waiting for a connection from this instance of the Data Source.

Here’s a sample view of the Statistics panel:

oracle weblogic book oracle weblogic books

Testing Oracle Weblogic Data Source

This option is available by selecting your Data Source and clicking on Monitoring | Testing sub tab. There you can test your Data Source against the Database, as shown by the following picture:

oracle weblogic book oracle weblogic books

Francesco Google+