• Blog
  • Get Help Now!
  • Customer Portal

BlueGecko Denmark

  • Why you need us
    • Why act now
    • Why are we unique
  • What we do
    • Products Supported 24/7
      • MySQL
      • Postgres
      • SQL Server
      • Open Source
      • OS & Storage
  • How we do it
    • Consulting
    • System Monitoring
    • Security
  • Support
    • Blog
      • Oracle
      • MySQL
      • News & Events
      • Oracle Applications
      • Amazon Web Services
      • Jeremiah Wilton’s Oradeblog
      • OurSQL Community Podcast
      • Remote DBA
    • Team viewer
    • Whitepapers
  • About Us
    • Philosophy
    • The Blue Gecko Teams
    • Employment Opportunities
    • Partners
    • News
    • Press
  • Contact Us

November 4, 2013 by lbjensen

Zabbix – Oracle monitoring

To follow up on post recently blog about the zabbix system monitoing tool we have installed the Orabix for Oracle monitoring.

This tool can:

  1. DBVersion (and relative validity of package)
  2. Archive ( archive log production with relative trend)
  3. EventWaits (monitor Files I/O,single block read, multiblock read, direct path read,SQLNet messages,  Controlfile I/O,LogWrite)
  4. HitRatio (monitor Hit Ratio on Trigger, Tables/Procedures, SQLArea,Body)
  5. Logical I/O (monitor Logical I/O values of : Current Read, Consistent Read, Block Change)
  6. PGA memory
  7. SGA (in particolar: Fixed Buffer, Java Pool, Large Pool, Log Buffer,Shared Pool,Buffer Cache)
  8. Physical I/O (Redo Writes,Datafiles Writes,Datafiles Read)
  9. SharedPool (Pool Dictionary Cache, Pool Free Memory, Library Cache,Sql Area ,Misc.)
  10. Pin Hit Ratio (monitor Hit Ratio on Trigger, Tables/Procedures, SQLArea,Body)
  11. Session/Processes (monitor Sessions and processes)
  12. Session (Active Session, Inactive Sessions, System Session)
  13. Graphs of the above
  14. Tablespace report (together with iReports and self developed MySQL procedures)
  15. 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.

Filed Under: System monitoring Tagged With: database monitoring, orabbix, Oracle, system monitoring, zabbix

Categories

  • Amazon Web Services
  • Configuration Management
  • downtime
  • Drizzle
  • ebs
  • Education
  • elastic block store
  • elastic compute cloud
  • hosting
  • hot backup
  • ignorance
  • Infrastructure
  • IOUG
  • Jeremiah Wilton's Oradeblog
  • misconception
  • misconceptions
  • Monocle
  • MySQL
  • MySQL Council
  • News
  • News & Events
  • Oracle
  • Oracle APEX
  • Oracle Applications
  • Oracle Data Guard
  • Oracle Database
  • Oracle Database Appliance
  • Oracle Linux
  • Our People
  • OurSQL Community Podcast
  • outage
  • parallel
  • performance
  • podcast
  • proof
  • Remote DBA
  • replication
  • S3
  • Security
  • SQL Server
  • System monitoring
  • Tomcat
  • Uncategorized

Contact Blue Gecko

  • This field is for validation purposes and should be left unchanged.

Get Our Newsletter

  • This field is for validation purposes and should be left unchanged.

The Fine Print

  • Privacy Policy
  • Terms of Use
  • When is remote DBA the right solution
  • What are remote DBA services
  • Get Help

Blog Categories

  • 24/7 support
  • Blue Gecko 360° Services
  • Products Supported 24/7

Virtual runs

Contact Blue Gecko

Blue Gecko A/S
Slotsgade 21
DK – 4200 Slagelse
Denmark
Phone: (DK) +45 70 60 51 20

Networks

  • Email
  • Twitter

© Blue Gecko Group