How to Install, Setup and Use the AQ Performance Monitor Package DBMS_AQ_MONITOR
(Doc ID 1163083.1)
Last updated on DECEMBER 16, 2019
Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Information in this document applies to any platform.
The purpose of this document is to provide an overview of the dbms_aq_monitor package which can be used to monitor queue performance and provide statistics on Advanced Queueing (AQ) queue operations within a single instance or Real Application Cluster (RAC) environment.
This is intended for anyone who needs to monitor or tune performance in an Advanced Queueing database.
The procedure can be executed in a 10.2 database onwards but note this procedure will only gather detailed performance information on buffered queues in this version. In 11.1 onwards the procedure will gather detailed performance information for persistent and buffered queues and this information is further enhanced in 11.2 to include notification and Queue Monitor statistics.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!