My Oracle Support Banner

Procedure to Manually Coalesce All the IOTs / Indexes Associated with Advanced Queueing Tables to Maintain Enqueue / Dequeue Performance; Reduce QMON CPU Usage and Redo Generation (Doc ID 271855.1)

Last updated on AUGUST 31, 2021

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 9.0.1.0 to 12.1.0.1 [Release 9.0.1 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Purpose

The purpose of this note is to document a procedure to workaround the issues discussed in <Bug 2965138>,  unpublished Bug 2890421 'KGL CACHE IN QMON FOR PERFORMANCE' and <Bug 3405618> and which will maintain enqueue/dequeue performance in an Advanced Queueing database.

Scope

Database administrators of Advanced Queueing and Streams databases.

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
 Benefits of performing a coalesce on AQ IOTs and indexes
References

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