Products documentation

The performance of the Oracle database is visible through several metrics. This monitor collects those metrics and allows to monitor their values: Data cache hit, Buffer cache hit, avg write time, etc…

Monitors the following metrics:

<lu> <li>Average read time (ms)</li> <li>Average write time (ms)</li> <li>Buffer cache</li> <li>Buffer cache hit ratio</li> <li>Data cache hit ratio</li> <li>Library cache hit ratio</li> <li>Number of invalid objects</li> <li>PGA sort in memory ratio</li> <li>Number of processes</li> <li>% of processes</li> <li>Number of sessions</li> <li>% of sessions</li> </lu>

Create a new rule and select the metric to monitor. Set its threshold with a numeric value or use the multi-threshold syntax.<br/> If you set a numeric value, the severity field will define alarm severity.<br/> This monitor will collect performance metrics according to its schedule and compare their values as defined in the rules, generating alerts when thresholds are breached.<br/><br/> To generate a metric for a given performance value, just select the appropriate metric and activate metric checkbox.