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.