This content has been marked as final. Show 2 replies
using DBMS_AQADM.CREATE_QUEUE_TABLE you can specify a new STORAGE_CLAUSE with INITRANS.
If the AQ table is empty during a downtime, this recreation of the AQ table should be the method of choice
(instead of a direct ALTER).
P.S.: There is a forum about all questions concerning Advanced Queueing:
I expect it will be a problem to get the queue empty. It is in heavy use.
PS: Can the moderator please move this thread to the correct forum (as indicated in the previous message)?