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: