Home » Server Options » Streams & AQ » dequeue script hang or not functioning (oracle advance queue)
dequeue script hang or not functioning [message #433417] Wed, 02 December 2009 04:35
cheehongjb
Messages: 7
Registered: January 2009
Location: Kuala Lumpur - MALAYSIA
Junior Member
Dear expert.

is there any posibility when i try to dequeue the queue from a queue table and it hang?

i did do some testing of 36k queue on my development machine to be dequeue and it was success from my script.

but when i deploy the script to real server the script just hang.

NOTE: total queue in the table is 1289091.

even i not use loop to dequeue the table and just dequeue 1 record also hang.

is there any other way for me to dequeue or remove the record from the queue?

best regards

Report message to a moderator

Previous Topic: AQ with Callback stop working
Next Topic: Multiple Master Databases, but one replication site
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 08 07:56:18 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.