GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

is it possible to achieve exponential retry-delay on AQ?

edited Feb 11, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered ✓

I would like to find out if it is possible to setup exponential retry delay on Oracle AQ subscription

if the message is dequed from the AQ and cannot be processed I would like to rollback the meesage to the queue and retry after 1 min then 2 min and 8 hours

I am using publish and subscribe method where a subscription is a pl/sql procedure within the same db (I am not using queue to queue propagation)

DBMS_AQADM.CREATE_QUEUE(
queue_name => l_queue_name,
queue_table => l_qtable_name,
max_retries => 3,
retry_delay => 1,
retention_time => 1209600
);

retry delay is a constant number and is not exponential

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center