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 220.127.116.11 to 18.104.22.168 [Release 8.1.7 to 11.2]
Oracle Database - Personal Edition - Version 22.214.171.124 to 126.96.36.199 [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|