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