开发者

How to set max_retries to unlimited on an OracleAQ queue

开发者 https://www.devze.com 2023-02-28 04:10 出处:网络
I have set up a queue in OracleAQ.If I understand the settings correctly this configuration will try each hour for 168 hours before removing the message:

I have set up a queue in OracleAQ. If I understand the settings correctly this configuration will try each hour for 168 hours before removing the message:

 EXEC dbms_aqadm.create_queue(queue_name=>'MYT_INFO_QUEUE',queue_table=>'MY_QUEUE_TABLE',max_retries=>168,retry_delay=>60,retention_time=开发者_运维百科>3600);

How can I set the max_retries to unlimited? It seems that a value of 0 will never retry, and I didn't see any documentation as to how to set to unlimited. Is there a way, or do I need to just use a large number?


I believe there is no unlimited possible for the max_retries

The maximum value of max_retries is 2**31 -1.

Refer This

0

精彩评论

暂无评论...
验证码 换一张
取 消