I see the following in Ignite:
The top line shows SPID 91 as a head blocker with the notation "idle blocker", blocking SPID 179. How can I find what is causing the blocking?
In line 5, SPID 91 is again shown as a head blocker, this time with the notation "blocker" and the full details that I need to diagnose the situation. Is this relevant with regard to the idle blocker shown in line 1?
Thanks,
Mark