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

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 10.2.0.3 this was a bug. However we are using 10.2.0.4

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,
OraKaran
Re: cursor: pin S wait on X in Oracle 10.2.0.4 [message #318413 is a reply to message #318382] Tue, 06 May 2008 16:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,
id1, id2, lmode, request, type
FROM V$LOCK
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 10.2.0.4 [message #321296 is a reply to message #318382] Mon, 19 May 2008 16:27 Go to previous message
moatazmizo
Messages: 1
Registered: May 2008
Junior Member
Hi
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: Sat Dec 10 22:40:01 CST 2016

Total time taken to generate the page: 0.04917 seconds