Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> problem=> cursor: pin S wait on X
Khurram Irshad
post Nov 14 2006, 08:17 AM
Post #1


Group: Members
Posts: 13
Joined: 21-August 06
Member No.: 4,869

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
Go to the top of the page
+Quote Post
post Nov 14 2006, 09:40 AM
Post #2

Advanced Member

Group: Members
Posts: 12,560
Joined: 26-January 04
Member No.: 13

Hi Khurram,

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


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

Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post
post Jun 7 2011, 06:10 PM
Post #3

Advanced Member

Group: Admin
Posts: 230
Joined: 25-September 07
Member No.: 12,334

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


Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 9th October 2015 - 12:39 PM