My Oracle Support Banner

DBMS_AQADM.REMOVE_SUBSCRIBER Does Not Remove A Subscriber From AQ$_<queue_table>_S (Doc ID 2403761.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Configured a multisubscriber-Queue in Oracle 12.1 version. Advanced Queuing subscriber has been removed from the queue table using DBMS_AQADM.REMOVE_SUBSCRIBER procedure. Still, this subscriber can be seen in the Data Dictionary view AQ$_<queue_table>_S with the Subscriber Type-66 and it is steadily growing daily.but the subscriber had no pending entries in the in the history table AQ$_<queue_table>_H.

Changes

We observed like when they add_subscriber with a rule based and then run the remove the subscriber and there is no message for this subscriber then the row in AQ$_<queue_table>_S gets deleted.If there is a message at that time then row stays and subscriber_type is changed to 66.When a new subscriber with same name does subscribe again a new subscriber gets created with subscriber-type 65.The subscriber-Type 66 stay there forever and grows steadily.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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