Re: query for waiters queue

From: John D Parker <>
Date: Wed, 16 Jan 2013 10:32:23 -0800 (PST)
Message-ID: <>

It appears that you win the prize!

 From: Sriram Kumar <> To:
Cc: oracle-l <> Sent: Wednesday, January 9, 2013 7:51 PM Subject: Re: query for waiters queue  


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!

Received on Wed Jan 16 2013 - 19:32:23 CET

Original text of this message