This content has been marked as final. Show 3 replies
To save disk space :-) please look at the thread on this forum entitled 'Lost Messages'. This should help a little with your question.
The information helped me a lot, just a few questions remain:
- How is the payload stored once it hits the HUB? Is AQ used, or DB tables?
- How does InterConnect determine when to delete messages from the HUB queue when multiple apps are subscribed to the message.
The payload is stored in OAI_HUB_QUEUE which is AQ queue.
Messages are expired/deleted from the queue as soon as all the subscribers have consumed the message. The message is cleaned up by the queue monitor process.
For the AQ queue monitor to work you need to have following init.ora parameters in the database set to non-zero:
The queue monitor is an optional background process that monitors messages in the queue. It provides the mechanism for message expiration, retry, and delay and allows you to collect interval statistics.