Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Advanced queue not removing PROCESSED messages from its queue table

SantoshVSMar 2 2010 — edited Mar 6 2010

Hi,

We have 6 advanced queues in our DB (Oracle 10g) and all are working fine. The problem is out of the six AQ, one specific AQ which used to work properly is not able to remove the PROCESSED messages from the AQ at one particular point of time. This is happening inconsistently.

When all the consumers has dequeued the message from this AQ, the message state becomes 'processed' and it grows large in millions untill we have to purge the queue table manually.

To give more info, aq_tm_processes is "unset" in the spfile/pfile and i am not the DBMS_AQADM.START_TIME_MANAGER is running and taking care of removing the 'processed' messages.

I am not a DBA guy and i think this has to do something with the Oracle AQ behavior. Need help on this please.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2010

Added on Mar 2 2010

#advanced-queueing, #database-key-features

4 comments

6,018 views