My Oracle Support Banner

What Objects Are Created When Creating a Queue Table ? (Doc ID 224027.1)

Last updated on JANUARY 18, 2021

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 8.1.7 to 11.2]
Oracle Database - Personal Edition - Version to [Release 8.1.7 to 11.2]
Information in this document applies to any platform.


The purpose of this document is to give the reader an understanding of the objects created at database level and when running the API DBMS_AQ_ADM.CREATE_QUEUE_TABLE.

NOTE: The API DBMS_AQ_ADM.CREATE_QUEUE_TABLE has different options, therefore some of the objects listed below may not be created. It depends on the arguments used.

This article is also not intended to discuss AQ memory structures used to handle certain messages.


The information shown here is not applicable for releases 8.0 and not for those queue tables created with compatible parameter set to '8.0'.

As the objects created may vary across RDBMS releases, some specific comments point that out as well.


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
 Objects always created
 Objects created only for multiple consumers queue tables
 Objects specific prior to release 9iR2

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