Re: query for waiters queue

From: Sriram Kumar <>
Date: Thu, 10 Jan 2013 09:51:50 +0800
Message-ID: <>

you can look at the following script by Guy Harrison. Displays the chain of locks

best regards

sriram kumar

On Thu, Jan 10, 2013 at 12:27 AM, John D Parker <> wrote:

> So I have all the classic queries for finding blockers and waiters. I keep
> running into the situation where I have one holder and 600 waiters. I clear
> off the blocker and then another one picks up and blocks. Is there a query
> that will give the current waiter queue? I see that Jonathan talks about a
> trace event to create a trace file but that's not particularly useful in my
> situation. Anyone have a query for this?
> Thanks in advance!
> John
> --

Received on Thu Jan 10 2013 - 02:51:50 CET

Original text of this message