Oracle Monitoring With Nagios

Capabilities

Nagios provides complete monitoring of Oracle database servers and databases – including availability, database and table sizes, cache ratios, and other key metrics.

The easy to use built-in Oracle Serverspace Wizard features metrics like:

• Connection Time
• Connected Users
• SGA Data Buffer Hit Ratio
• SGA Library Cache Hit Ratio
• SGA Dictionary Cache Hit Ratio
• SGA Shared Pool Free
• PGA In Memory Sort Ratio
• Soft Parse Ratio
• Retry Ratio
• Redo I/O Traffic
• Roll Header Contention
• Roll Block Contention
• Roll Hit Ratio
• Roll Wraps
• Roll Extends
• Flash Recovery Area Usage
• SGA Latches Hit Ratio

Nagios XI also includes an Oracle Tablespace Wizard that allows administrators to gain insight on:

• Tablespace Usage
• Tablespace Free Space
• Tablespace Remaining Time Until Full
• Tablespace Fragmentation
• Tablespace IO Balance
• Can Allocate Next Extent

Benefits

Implementing effective Oracle monitoring with Nagios offers the following benefits:

• Increased application availability
• Increased database performance
• Fast detection of database outages, failures, and table corruption
• Predictive analysis of storage requirements and index performance

How to Install and Configure the Oracle Client and Plugins

Learn how to install Oracle plugins in Nagios XI and how to configure your environment to utilize the Oracle plugins to monitor Oracle databases with Nagios XI.

How to Install and Configure the Oracle Client and Plugins

Solutions

These Nagios solutions provide Oracle monitoring capabilities and benefits:

• Nagios XI
• Nagios Core

Resources

• Oracle Monitoring plugins
• Oracle Server Wizard
• Oracle Tablespace Wizard
• Oracle Query Wizard

See Also

• Database Monitoring