Home » Server Options » Streams & AQ » process or task in queue is not dequeue
process or task in queue is not dequeue [message #431430] Tue, 17 November 2009 05:32 Go to next message
cheehongjb
Messages: 7
Registered: January 2009
Location: Kuala Lumpur - MALAYSIA
Junior Member
May i know any reason it cause the queue is not dequeue?

best regards
terence

Report message to a moderator

Re: process or task in queue is not dequeue [message #431432 is a reply to message #431430] Tue, 17 November 2009 05:39 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
/forum/fa/1600/0/

What queue?

Oracle Advanced Queueing related?

Job Queue related?

Related to Data Guard?

Related to Oracle Streams?

Related to Java Message Service?

Related to Oracle Enterprise Service Bus?

Can you explain in more detail what you are talking about?

Report message to a moderator

icon10.gif  Re: process or task in queue is not dequeue [message #431435 is a reply to message #431432] Tue, 17 November 2009 05:49 Go to previous messageGo to next message
cheehongjb
Messages: 7
Registered: January 2009
Location: Kuala Lumpur - MALAYSIA
Junior Member
Sorry for the incomplete information.

I not sure it is category under which.

it is an object in oracle.
i attach a picture from plsql developer.



best regards
terence chua

Report message to a moderator

Re: process or task in queue is not dequeue [message #431441 is a reply to message #431430] Tue, 17 November 2009 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68348
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe because noone is dequeuing something from it?

Regards
Michel

Report message to a moderator

Re: process or task in queue is not dequeue [message #431517 is a reply to message #431441] Tue, 17 November 2009 21:21 Go to previous message
cheehongjb
Messages: 7
Registered: January 2009
Location: Kuala Lumpur - MALAYSIA
Junior Member
Did it related to the setting of AQ_TM_PROCESSES

or the retention_time parameter in the queue was 0.

Best Regards
Terence

Report message to a moderator

Previous Topic: AQ_TM_PROCESSES, which value?
Next Topic: AQ with Callback stop working
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 05 01:46:35 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.