cursor: pin S wait on X

From: "Schultz, Charles" <sac@xxxxxxxxxxxxx>
To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 28 Apr 2006 11:28:37 -0500

How does one translate the p2 and p3 values for wait event "cursor: pin
S wait on X"? The documentation simply says:

A session waits for this event when it is requesting a shared mutex pin
and another session is holding an exclusive mutex pin on the same cursor
object.

Wait Time: Microseconds

Parameter        Description     
P1       Hash value of cursor    
P2       Mutex value (top 2 bytes contains SID holding mutex in
exclusive mode, and bottom two bytes usually hold the value 0)   
P3       Mutex where (an internal code locator) OR'd with Mutex Sleeps


cursor: pin X



charles schultz
oracle dba
aits - adsd
university of illinois


--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: cursor: pin S wait on X
From: Ray Stell

cursor: pin S wait on X

Other related posts: