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 laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.1.7.0 to 11.2.0.3 [Release 8.1.7 to 11.2]
Oracle Database - Personal Edition - Version 8.1.7.0 to 11.2.0.3 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
Purpose
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.
Scope
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.
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 |
| Objects always created |
| Objects created only for multiple consumers queue tables |
| Objects specific prior to release 9iR2 |
| References |