We have already mentioned that ZenMon has become a native cross-platform database monitoring tool for Oracle, MySQL, PostgreSQL using the Zabbix Agent. But what metrics and triggers it monitors - no. We think it's time to start!
ZenMon was updated with Zabbix v4.4 and combined not only classic popular open-source management systems - MySQL and PostgreSQL, but also commercial products - Oracle and Microsoft SQL Server. Let's consider what specific ZenMon monitoring indicators Oracle has. Only for this type of databases: 80 metrics and 70 triggers.
Here is a part of these metrics for monitoring on Oracle version 10g/11g/12c/18c/19c:
- - Basic instance metrics (uptime, availability, status, sessions, processes, data file limits, locks, archiver status and so on);
- - Single database/Pluggable database (size, role, open_mode, flashback, etc.);
- - Fast Recovery Area (FRA);
- - Monitoring backups;
- - Monitoring permanent, undo, temporary tablespace;
- - Monitoring Dataguard (MRP status, apply and transport lag);
- - Monitoring errors in alert.log (ORA-00600 and others);
- - Monitoring Archive Log Destination;
- - Monitoring instance parameters (changing default parameters);
- - Automatic Storage Management (Oracle ASM) monitoring;
- - Monitoring Listener Performance.
ZenMon allows you to customize the data being collected. It means that you can create your own item's and write SQL queries in the configuration file. What a cherry on the cake: open source under GPLv2 license.
DBserv > Blog > Monitoring SQL Queries in Oracle Database