SessionWaitMonitor

Task Type: Database Monitor
Configurable: Yes
Host Dependent: No
Schedule Dependent: No

Description

The SessionWaitMonitor monitors the V$SESSION_WAIT view and generates an alert when the number of session waits detected during multiple samples exceeds one or more thresholds.

Configuration

The <SessionWaitMonitorConfig> is configured with the following attributes:

Attribute Required Description
SAMPLES Yes The number of times to sample the V$SESSION_WAIT view per task execution.
INTERVAL Yes The interval (in seconds) between samples. Must be a positive integer.
WAITS_PER_SAMPLE Yes The maximum allowed number of waits that can occur in any one sample. An alert is generated when the number of session waits exceeds this threshold.
WAITS_IN_RANGE Yes See WAITS_RANGE_SAMPLES
WAITS_RANGE_SAMPLES Yes An alert is generated when a consecutive number of samples (defined by WAITS_RANGE_SAMPLES) all contain more than some number of session waits (defined by WAITS_IN_RANGE).

Example

<SessionWaitMonitorConfig SAMPLES="5"
                          INTERVAL="5"
                          WAITS_PER_SAMPLE="8"
                          WAITS_IN_RANGE="3"
                          WAITS_RANGE_SAMPLES="5"/> 

In this example, TCAgent samples the V$SESSION_WAIT view five times, pausing five seconds between each sample. An alert is sent if any individual sample contains more than eight session waits, or if three consecutive samples each contain more than five session waits.

Usage Notes

  • Take the values for SAMPLES and INTERVAL into consideration when scheduling this task. In the example above, the task takes 25 seconds to execute. Avoid scheduling the task more frequently than the length of time it takes for the task to execute.
  • This task ignores idle session waits.
Your Source for Oracle Expertise