Re2: Odd new symptom - database locking up on a query

Even more additional information:

If I let the database sit for tens of minutes, it will come back to life,
slowly. Then, a few minutes later, the cycle will repeat again.

Any ideas?

Thanks,

Doug

At 11:20 PM 7/6/2002, Doug Fields wrote:
>Additional information from the STATS being turned on:
>
>(The static IN clause has between 250 and 350 IDs in it, each time. I
>don't know which DELETE hangs first, but they all cascade into being hung,
>as this shows.)
>
>Thoughts?
>
>Thanks,
>
>Doug