Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> cursor: pin S wait on X

cursor: pin S wait on X

From: Schultz, Charles <sac_at_uillinois.edu>
Date: Fri, 28 Apr 2006 11:28:37 -0500
Message-ID: <565F609E6D736D439837F1A1A797F34171D3DC@ADMINMAIL1.ui.uillinois.edu>


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
Received on Fri Apr 28 2006 - 11:28:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US