Oracle 11.2 AQ queue-to-queue propagation of 21M rows backlog. How to change propogation to process smaller sets of rows at a time
I have inherited an AQ system and had to do a database restore of DB1 (reseed) from a backup. I have substututed real names of queues and links etc with generic names for security’s sake in the decsription. There is now a 21M row backlog in the the DB1_queue in database DB1. Queue to queue propagation is set up to another queue_DB3 in another database DB3.
There is also another queue_DB2 in a different database DB2 that is working fine and propagating to the DB3_queue. The DB2 database was also restored for a reseed from a backup.