Ressources

Database Monitoring

Oracle

Oracle database plug-in monitoring capability helps database administrators monitor the performance and availability of an Oracle database through Oracle OCI client.

Some of the counters available are :

  • Bytes received.
  • Bytes send.
  • Connection time.
  • Instance used Space.
  • Logical reads.
  • Physical reads.
  • Physical writes.
  • User calls.
  • User commits.
  • User rollbacks.

MySQL

MySQL Server plug-in monitoring capability helps database administrators monitor the performance and availability of a MySQL database farm.

Some of the counters available are :

  • Aborted Clients.
  • Aborted Connects.
  • Bytes received.
  • Bytes send.
  • Connection time.
  • Database Size.
  • Table locks waited.
  • Threads connected.
  • Threads running.

MultiDB

The Orsenna’s SQL MultiDB Query Monitor plug-in allows the monitoring of different types of database like Mysql, PostgreSQL, DB2, Oracle, Sybase and Informix.

With this plug-in we could execute a custom SQL query to compare the result using a threshold.

You are also able to use an external SQL request file with a script processing facility . This allow you to make process the results from your database.