My Oracle Support Banner

How to Install, Setup and Use the AQ Performance Monitor Package DBMS_AQ_MONITOR (Doc ID 1163083.1)

Last updated on SEPTEMBER 12, 2018

Applies to:

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.

Purpose

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.

Scope

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.

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
 Purpose
 Overview
 Design Description
 Package Specification
 Set/get Monitor Configuration Procedures
 ADD_QUEUE_OWNER Procedure
 REMOVE_QUEUE_OWNER Procedure
 SET_LOG_DIR Procedure
 SET_MONITORING_PARAM Procedure
 SHOW_CONFIG Procedure
 Monitor Control Procedures
 START_MONITOR Procedure
 STOP_MONITOR Procedure
 DESTROY_MONITOR Procedure
 CLEAR_SCHEDULE_JOB Procedure
 GET_REPORT Procedure
 GET_ALL_QUEUES_REPORTS Procedure
 GET_SUBREG_REPORT Procedure
 AQMonitor Files
 Usage
 Notes and Restrictions
 Plotting the Data Generated
 Sample Results

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.