Orabbix is an interesting and useful application able to monitor oracle instances with zabbix.
With Orabbix, a user can acquire data from every oracle instances that he wants to monitor. After that, zabbix server will produce graphs and collect data from that certain database.
Most of data collection applications are using some trigger that send mail for each trouble funded or performance problem. However, this is not really the most "useful" data recording system. It's incredibly important to collect information and produce SLA or to have a workload history of your database. Orabbix can help you accomplish that.
It is hard to list all major features available in Orabbix. However, we can point out some of the most important ones. Here is a short list with some Orabbix core features and options:
- It can set or identify the database version (and relative validity of package)
- Event Waits feature (monitor Files I/O, single block read, multi block read, direct path read, SQLNet messages, Control file I/O, Log Write)
- Logical I/O (monitor Logical I/O values of: Current Read, Consistent Read and Block Change)
- SGA (in particular: Fixed Buffer, Java Pool, Large Pool, Log Buffer, Shared Pool, Buffer Cache)
- Shared Pool (Pool Dictionary Cache, Pool Free Memory, Library Cache, Sql Area, etc.)
- Session/Processes (monitor Sessions and processes)
- Archive (archive log production with relative trend)
- Hit Ratio (monitor Hit Ratio on Trigger, Tables/Procedures, SQLArea and Body)
- Physical I/O (Redo Writes, Data files Writes, Data files Read)
- Pin Hit Ratio (monitor Hit Ratio on Trigger, Tables/Procedures, SQLArea and Body)
- Session (Active Session, Inactive Sessions, System Session)
Why is Orabbix famous?
Orabbix is famous because it is an interesting and useful application able to monitor oracle instances with zabbix.
Publisher: Andrea Dalle Vacche
Tags: database enquiry, Oracle database,