Orabbix has received a lot of award there is a dedicated page available here.
Everyone can read the full story of this plug-in here:
And here:
There is an interesting interview with the author available here:
Distribution and files are available directly from here:
About
Orabbix was made to monitor oracle instances with zabbix, with this you are going to acquire data from every oracle instances that you want to monitor and then zabbix server is going to produce graphs and collect data. For most of data collected are present some trigger that send mail for each trouble funded or performance problem. It’s incredibly useful to collect data and produce SLA or to have a workload history of your DB.
What Orabbix actually keep under his control:
- 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
- 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)
For installation instruction please read this page.
