products:promonitor:6.8:monitorsguide:oracle:oracleperformances

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

ParameterDescription
ActiveTo enable/disable a rule
Performance metricThe Oracle performance metric to monitor
ThresholdThe threshold used for the metric (Numeric of multi-threshold)
Auto clearIf checked, the alarm will be cleared as soon as the alarm condition is not met anymore
Alarm tagThis 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.
AlarmTo enable alarm sending
MetricTo enable metric sending
ReportIf checked, this line of surveillance will used for showing threshold and severity in the daily report, if available.

Generated metrics

metricIdmetricUnitmetricTargetmetricDescription
ORACLE_DATABASE_PERF_AVG_READ_TIMEAverage read time (hs)
ORACLE_DATABASE_PERF_AVG_WRITE_TIMEAverage write time (hs)
ORACLE_DATABASE_PERF_BUFFER_CACHEBuffer cache
ORACLE_DATABASE_PERF_BUFFER_CACHE_HIT_RATIOBuffer cache hit ratio
ORACLE_DATABASE_PERF_DATA_HIT_CACHEData hit cache
ORACLE_DATABASE_PERF_INVALID_OBJ_NUMInvalid objects (number of)
ORACLE_DATABASE_PERF_LIBRARY_CACHE_HIT_RATIOLibrary cache hit ratio
ORACLE_DATABASE_PERF_PGA_SORT_IN_MEMORY_RATIOPGA sort in memory ratio
ORACLE_DATABASE_PERF_PROCESSES_CURRENT_NUMProcesses (current number of)
ORACLE_DATABASE_PERF_PROCESSES_CURRENT_PCTProcesses (current number percentage)
ORACLE_DATABASE_PERF_SESSIONS_CURRENT_NUMSessions (current number of)
ORACLE_DATABASE_PERF_SESSIONS_CURRENT_PCTSessions (current percentage)
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/oracle/oracleperformances.txt · Last modified: 2022/10/25 12:02 by rbariou