Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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


Member
**

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


Advanced Member
***

Group: Members
Posts: 11,706
Joined: 26-January 04
Member No.: 13



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


--------------------
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
RHR
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:

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

RHR
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: 24th November 2014 - 02:56 AM