Modify retention period of workflow queues
Yesterday, there was a requirement to increase the retention period of WF_DEFERRED and WF_BPEL_Q so that the developers could troubleshoot issues involving business events. This can be done this way: 1. Check the retention period of existing workqueues. SQL> SELECT owner, name, retention FROM all_queues WHERE name LIKE 'WF%'; OWNER NAME RETENTION --------------- --------------------------------------------- ------------------------------ APPS WF_BPEL_Q 0 APPLSYS WF_INBOUND_QUEUE 0 APPLSYS WF_OUTBOUND_QUEUE 0 APPLSYS WF_SMTP_O_1_QUEUE 0 APPLSYS WF_DEFERRED_QUEUE_M 0 APPLSYS WF_DEFERRED 0 APPLSYS WF_ERROR 0 AP