Home » RDBMS Server » Performance Tuning » cursor: pin S wait on X in Oracle (Oracle on RHEL 4)
cursor: pin S wait on X in Oracle [message #318382] Tue, 06 May 2008 13:13 Go to next message
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member

We are constantly observing following Wait Event while executing a particular query

cursor: pin S wait on X

I checked on Internet and found that in Oracle this was a bug. However we are using

Also I queried X$MUTEX_SLEEP fixed table and following are the results.
Can anybody guide me regarding this?

select * from X$MUTEX_SLEEP ;

ADDR                   INDX    INST_ID MUTEX_TYPE           MUTEX_TYPE_ID LOCATION_ID LOCATION                                     SLEEPS  WAIT_TIME
---------------- ---------- ---------- -------------------- ------------- ----------- ---------------------------------------- ---------- ----------
0000002A974CFBD0          0          1 Cursor Parent                    2          27 kkspsc0 [KKSPRTLOC27]                             2         53

0000002A974CFC48          1          1 Cursor Parent                    2           1 kksfbc [KKSPRTLOC1]                               1         25

0000002A974CFC48          2          1 Cursor Pin                       3           5 kkslce [KKSCHLPIN2]                         7734050 1519721358

Thanks and Regards,
Re: cursor: pin S wait on X in Oracle [message #318413 is a reply to message #318382] Tue, 06 May 2008 16:12 Go to previous messageGo to next message
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,
id1, id2, lmode, request, type
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM V$LOCK WHERE request>0)
ORDER BY id1, request

If no rows is returned from the SQL above "while executing a particular query", then you really do not have any conflict.
Re: cursor: pin S wait on X in Oracle [message #321296 is a reply to message #318382] Mon, 19 May 2008 16:27 Go to previous message
Messages: 1
Registered: May 2008
Junior Member
we have same issue here did you fix your problem and how, we also have 10204
Previous Topic: How i tune database and sql
Next Topic: Moving table into same tablespace
Goto Forum:

Current Time: Tue Oct 25 12:59:01 CDT 2016

Total time taken to generate the page: 0.08923 seconds