Re: query for waiters queue

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Thu, 10 Jan 2013 09:51:50 +0800
Message-ID: <CAEq4C0d92a4x-gArcjus3-tPdDWnV0xh5fMN_CZ6Km4hu8AREw_at_mail.gmail.com>



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

http://guyh.textdriven.com/OPSGSamples/Ch15/wait_chains.sql

best regards

sriram kumar

On Thu, Jan 10, 2013 at 12:27 AM, John D Parker <orclwzrd_at_yahoo.com> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 10 2013 - 02:51:50 CET

Original text of this message