Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> cursor: pin S wait on X
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-lReceived on Fri Apr 28 2006 - 11:28:37 CDT