Home » Server Options » Streams & AQ » Purging a queue takes longer then expected
Purging a queue takes longer then expected [message #180347] Mon, 03 July 2006 03:09
Messages: 30
Registered: November 2005

I request every one to help me on this.

Purge script runs too long and its every time. I'm using 10g Rel2 on AIX. Any idea why does it take too long??

Its takes long even if there are one or two messages.

Also sometimes quering the table using a.user_data.get_string_property() takes a lot of time. Someone please advice me on this.

Thanks in adv.
Previous Topic: How to capture previous data in CDC
Next Topic: Able to browse but fails to dequeue...
Goto Forum:

Current Time: Wed May 31 15:29:36 CDT 2023