Action disabled: revisions
products:promonitor:6.8:monitorsguide:oracle:oracleperformances
Table of Contents
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) | ||
products/promonitor/6.8/monitorsguide/oracle/oracleperformances.txt · Last modified: by 127.0.0.1