Назад к списку

Monitoring SQL Queries in Oracle Database

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

Quick Links: Blog Contacts Prices
© 2008-2024. Sitemap