Products documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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)||