job hangs for mysterious reason

[cruel]

I have come across couple of instances when, an query job hangs forever no matter if it is a light job or a heavy job, but when I resubmit the job, it goes through smoothly even when the old job still hangs there. Any good explanations for that?

 

[SantaMufasa]

My Crystal Ball says, "It's possible."

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]