DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)

Before AQ users can enqueue and dequeue, they must have queues with which to work. The AQ administrator must create queue tables and queues within those tables and then start the queues. Additional administrative tasks include stopping queues and removing queue tables, managing lists of subscribers, and starting and stopping the Queue Monitor.

The DBMS_AQADM package provides an interface to the administrative tasks of Oracle AQ. The DBMS_AQADM programs are listed in Table 5.2. In order to use these procedures, a DBMS_AQADM user must have been granted the role AQ_ADMINISTRATOR_ROLE from the SYS account.

Note

None of the DBMS_AQADM programs may be used inside SQL, directly or indirectly. The reason for this restriction is that many of these programs perform a COMMIT (unless you have set the auto_commit parameter to FALSE).

Table 5-2. DBMS_AQADM Programs

Name

Description

Use in SQL?

ADD_SUBSCRIBER

Adds a subscriber to a queue.

No

ALTER_QUEUE

Alters limited set of properties of an existing queue.

No

CREATE_QUEUE

Creates a queue within the specified queue table.

No

CREATE_QUEUE_TABLE

Creates a queue table in which queues can be defined.

No

DROP_QUEUE

Drops an existing queue table.

No

DROP_QUEUE_TABLE

Drops an existing queue from a queue table.

No

GRANT_TYPE_ACCESS

Grants access to multiple consumer tasks.

No

QUEUE_SUBSCRIBERS

Retrieves the list of subscribers associated with a queue.

No

Get Oracle Built-in Packages now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.