OraFAQ Forum: Streams & AQ » How to dequeue after 30minutes it has been queued?

Home » Server Options » Streams & AQ » How to dequeue after 30minutes it has been queued? (oracle 11g)

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

How to dequeue after 30minutes it has been queued? [message #635620]

Thu, 02 April 2015 16:59

gentleman777us
Messages: 122
Registered: April 2005

Senior Member

Hi,

My task is to dequeue message if it is past 30 minutes after it has been qued. ie. How can I check the record in queue table if it has passed 30 minutes( should I take into account the enque time stamp?)

Iam new to advanced queue, I would appreciate if someone can provide me an example.

Thanks

Report message to a moderator

Re: How to dequeue after 30minutes it has been queued? [message #635621 is a reply to message #635620]

Fri, 03 April 2015 01:37

John Watson
Messages: 8970
Registered: January 2010
Location: Global Village

Senior Member

When you dequeue, check the value of message_properties_t.enqueue_time.

Report message to a moderator

Re: How to dequeue after 30minutes it has been queued? [message #650567 is a reply to message #635620]

Wed, 27 April 2016 13:38

jyeager
Messages: 4
Registered: April 2016
Location: Nashville

Junior Member

How about enqueuing the message with a delay?
At the time of enqueue, you specify a time 30 minutes in the future.
The message remains in the queue with a state=1 until the delay time is reached where one of the aq_tm_processes converts it to an active event (state=0) and it's available for dequeue.

Report message to a moderator

Previous Topic:	URGENT: Oracle queuing with poor performance
Next Topic:	Question about CDC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 23:51:37 CDT 2025