Re: query for waiters queue
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Jan 2013 08:30:56 -0000
I've just tried a simple test on an 11.2.0.3 instance.
Get 3 sessions to lock a table in exclusive mode - one gets it, the other
two queue.
The query returned no rows. In fact v$wait_chain held no rows.
I haven't checked the documentation yet, but the waits captured by
v$wait_chain may include all the common waits we might like.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
----- Original Message -----
From: "John D Parker" <orclwzrd@xxxxxxxxx>
To: "Sriram Kumar" <k.sriramkumar@xxxxxxxxx>
Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, January 16, 2013 6:32 PM
Subject: Re: query for waiters queue
| It appears that you win the prize!
|
| ________________________________
| From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
| To: orclwzrd@xxxxxxxxx
| Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
| Sent: Wednesday, January 9, 2013 7:51 PM
| Subject: Re: query for waiters queue
|
|
| 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@xxxxxxxxx>
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
| >
| >--
| >//www.freelists.org/webpage/oracle-l
| >
--
//www.freelists.org/webpage/oracle-l
Other related posts:
