Skip to Main Content

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!

Difference between AQ$TableName and Queue TableName

YJ7Sep 1 2010 — edited Oct 28 2010
Our BPEL process is listening to Business event from Oracle ebiz. Noticed the following

BE raised -> Message available in wf_deferred (queue table name) -> Message available in wf_bpel_qtab (queue table name) -> BPEL instance invoked.

After the above process ,noticed that the record state in wf_bpel_qtab is 0 and there is no value in dequeue time. On the other hand, in AQ$WF_BPEL_QTAB view, for the same message the state is Processed and dequeue time is populated.

1. Why there is difference in data AQ$TableName and queue TableName
2. Is there any process, to make sure that the data in both AQ$TableName and queue TableName are in sync
3. When the data will be deleted from queue TableName ? Currently, the retention value of the Queue is 0.

Thanks.
This post has been answered by 758358 on Sep 10 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2010
Added on Sep 1 2010
4 comments
2,544 views