Oracle Performances

Purpose

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...

Performance metrics

Monitors the following metrics:

Average read time (ms)

Average write time (ms)

Buffer cache

Buffer cache hit ratio

Data cache hit ratio

Library cache hit ratio

Number of invalid objects

PGA sort in memory ratio

Number of processes

% of processes

Number of sessions

% of sessions

Configuration hints

Create a new rule and select the metric to monitor.

Set its threshold with a numeric value or use the multi-threshold syntax.

If you set a numeric value, the severity field will define alarm severity.

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.

To generate a metric for a given performance value, just select the appropriate metric and activate metric checkbox.

Surveillance table

Parameter	Description
Active	To enable/disable a rule
Performance metric	The Oracle performance metric to monitor
Threshold	The threshold used for the metric (Numeric of multi-threshold)
Auto clear	If checked, the alarm will be cleared as soon as the alarm condition is not met anymore
Alarm tag	This field allows to add custom text within the alarm message. %MSG% variable will containthe actual generated message and can be used such as: “my_prefix %MSG% my_suffix”. By default, tagwill be used as prefix.
Alarm	To enable alarm sending
Metric	To enable metric sending
Report	If checked, this line of surveillance will used for showing threshold and severity in the daily report, if available.

Generated metrics

metricId	metricUnit	metricTarget	metricDescription
ORACLE_DATABASE_PERF_AVG_READ_TIME	Average read time (hs)
ORACLE_DATABASE_PERF_AVG_WRITE_TIME	Average write time (hs)
ORACLE_DATABASE_PERF_BUFFER_CACHE	Buffer cache
ORACLE_DATABASE_PERF_BUFFER_CACHE_HIT_RATIO	Buffer cache hit ratio
ORACLE_DATABASE_PERF_DATA_HIT_CACHE	Data hit cache
ORACLE_DATABASE_PERF_INVALID_OBJ_NUM	Invalid objects (number of)
ORACLE_DATABASE_PERF_LIBRARY_CACHE_HIT_RATIO	Library cache hit ratio
ORACLE_DATABASE_PERF_PGA_SORT_IN_MEMORY_RATIO	PGA sort in memory ratio
ORACLE_DATABASE_PERF_PROCESSES_CURRENT_NUM	Processes (current number of)
ORACLE_DATABASE_PERF_PROCESSES_CURRENT_PCT	Processes (current number percentage)
ORACLE_DATABASE_PERF_SESSIONS_CURRENT_NUM	Sessions (current number of)
ORACLE_DATABASE_PERF_SESSIONS_CURRENT_PCT	Sessions (current percentage)