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.
|
|
|