query for waiters queue
From: John D Parker <orclwzrd_at_yahoo.com>
Date: Wed, 9 Jan 2013 08:27:14 -0800 (PST)
Message-ID: <1357748834.29091.YahooMailNeo_at_web163103.mail.bf1.yahoo.com>
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!
Date: Wed, 9 Jan 2013 08:27:14 -0800 (PST)
Message-ID: <1357748834.29091.YahooMailNeo_at_web163103.mail.bf1.yahoo.com>
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-lReceived on Wed Jan 09 2013 - 17:27:14 CET