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
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
Previous Topic: AQ with Callback stop working
Next Topic: Multiple Master Databases, but one replication site
Goto Forum:

Current Time: Mon Feb 06 06:36:09 CST 2023