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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
