Removing RIB_TAFR Subscriber Taking Too Long
(Doc ID 2965914.1)
Last updated on AUGUST 07, 2023
Applies to:Oracle Retail Integration Bus - Version 16.0.3 and later
Information in this document applies to any platform.
The user is trying to remove all RIB_TAFR subscribers due to decommissioning. User is using this SQL:
FOR myname in (select queue_name,consumer_name from dba_queue_subscribers where consumer_name like '%RIB_TAFR%') loop
subscriber := sys.aq$_agent (myname.consumer_name, NULL, null);
queue_name => myname.queue_name,
subscriber => subscriber);
It is taking too long because there are a huge number of records on 1 queue - ETSOSTATUS. Which has 35 million records.
What is the best way to remove this? Also, is it possible to do it while RIB is running and will it impact any running processes?
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