==== 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:

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