AQ Time Manager: Automated Health Monitor & Stats Collector for DELAY (WAIT) messages
(Doc ID 3059804.1)
Last updated on NOVEMBER 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to Beta 23ai [Release 12.1 to 23]Information in this document applies to any platform.
Purpose
Automated shell script that monitors the AQ Queues for significant lag while processing messages with DELAY (WAIT), and automatically collects the stats for Time Manager slaves, QMON Job Cache, Message stats etc. required to investigate the potential issues.
Scope
This note is intended for anyone interest on retrieving information about current status of AQ Queue stats. This script do not modify the AQ configuration. The script reports important information on the setup and operation of AQ. This will provide a consistent basis upon which to understand what is happening in the environment and aid to diagnose issues.
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Scope |
| Details |