problem=> cursor: pin S wait on X Options

[Khurram Irshad]

Hello every one
i am using the Oracle 10 g 10.2 with the windows 2003
3 sessions from a single User shows the currenncy on the top activity graph of the enterprice manager
they are not getting so much resources of system....when i go in the detail of the session i get

cursor: pin S wait on X

i am unable to kill these sessions
can any one suggest the how could i get rid of these sessions
Regards
khurram

[burleson]

Hi Khurram,

This is a complex error! You may want to open an SR on metalink:

http://metalink.oracle.com

It's a semaphore (mutex) issue, an exclusive lock . . .

Check out V$MUTEX_SLEEP and V$MUTEX_SLEEP_HISTORY for more details . . .

The Oracle docs note:

cursor: pin S wait on X

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

[RHR]

For quick reference, the information on the deadlock difference between Oracle 10g and 11g is here:

http://dba-oracle.com/t_oracle_deadlock_di...10g_and_11g.htm

RHR