OraFAQ Forum: Streams & AQ » Dequeuing from multiple queue by priority

Home » Server Options » Streams & AQ » Dequeuing from multiple queue by priority

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dequeuing from multiple queue by priority [message #280626]

Wed, 14 November 2007 04:44

ydelanoe
Messages: 4
Registered: October 2007

Junior Member

Hi,

Is there a way for a process to dequeue the most prioritary message from a range of queues without having to do a previous SQL request on my queue table ?

Thanks for your help and comments.
Yd

Report message to a moderator

Re: Dequeuing from multiple queue by priority [message #280628 is a reply to message #280626]

Wed, 14 November 2007 04:49

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

BY which you can say the message has more priority? Any criteria. There is a parameter commit_serialization whose value is full/none.

[Updated on: Wed, 14 November 2007 04:53]

Report message to a moderator

Re: Dequeuing from multiple queue by priority [message #280632 is a reply to message #280628]

Wed, 14 November 2007 04:58

ydelanoe
Messages: 4
Registered: October 2007

Junior Member

I use the AQ priority option when enqueuing.
My process shall get the most prioritary from a range of queues.
If there are many messages with the highest priority, I dont mind wich one of them will be dequeued.

Report message to a moderator

Previous Topic:	multi-directional synchronization
Next Topic:	Embed Oracle AQ to JBoss using JMS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 22 06:27:00 CDT 2025