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.
