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