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 22.214.171.124 and later
Information in this document applies to any platform.
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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!