My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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

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