To follow up on post recently blog about the zabbix system monitoing tool we have installed the Orabix for Oracle monitoring.
This tool can:
- DBVersion (and relative validity of package)
- Archive ( archive log production with relative trend)
- EventWaits (monitor Files I/O,single block read, multiblock read, direct path read,SQLNet messages, Controlfile I/O,LogWrite)
- HitRatio (monitor Hit Ratio on Trigger, Tables/Procedures, SQLArea,Body)
- Logical I/O (monitor Logical I/O values of : Current Read, Consistent Read, Block Change)
- PGA memory
- SGA (in particolar: Fixed Buffer, Java Pool, Large Pool, Log Buffer,Shared Pool,Buffer Cache)
- Physical I/O (Redo Writes,Datafiles Writes,Datafiles Read)
- SharedPool (Pool Dictionary Cache, Pool Free Memory, Library Cache,Sql Area ,Misc.)
- Pin Hit Ratio (monitor Hit Ratio on Trigger, Tables/Procedures, SQLArea,Body)
- Session/Processes (monitor Sessions and processes)
- Session (Active Session, Inactive Sessions, System Session)
- Graphs of the above
- Tablespace report (together with iReports and self developed MySQL procedures)
- Custom checks (just need the sql to be executed)
We are using the Orabbix together with zabbix proxy feature. This gives the ability to monitor several hosts/databases and have it all sent to the zabbix-server at one time. This also simplifies changes to the standard monitoring of hosts, because it is only requeired to change the monitor checks 1 place.
We have succesfully installed the zabbix proxy on a raspberry pi. This makes it very easy to setup a zabbix monitoring setup at our customer site.