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
sanju.sinha@gmail.com
Messages: 30
Registered: November 2005
Member

Hello,
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: Thu Mar 28 03:15:34 CDT 2024