Redpeaks V6.8
Trouble shooting
Monitors Guide
Sidebar
products:promonitor:6.8:monitorsguide:oracle:oracleperformances
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help 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) | ||
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/oracle/oracleperformances.txt · Last modified: 2024/05/01 18:35 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
