oracle wait event:cursor: pin S wait on X

oracle wait event:cursor: pin S wait on X
cursor: pin S wait on XµÈ´ýʼþµÄ´¦Àí¹ý³Ì
http://database.ctocio.com.cn/tips/114/8263614_1.shtml
cursor: pin S wait on XµÈ´ý£¡
http://www.itpub.net/viewthread.php?tid=1003340
½â¾öcursor: pin S wait on X ÓÐʲôºÃ°ì·¨:
http://www.itpub.net/thread-1163543-1-8.html
cursor: pin S wait on X:
http://space.itpub.net/756652/viewspace-348176
cursor: pin S:
http://yumianfeilong.com/html/2008/11/01/254.html
OTNµÄ½âÊÍ,
cursor: pin SA session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of updating a shared mutex pin for the same cursor object. This wait event should rarely be seen because a shared mutex pin update is very fast.(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
Oracle10gÖÐÒýÓõÄmutexes»úÖÆÒ»¶¨³Ì¶ÈµÄÌæ´úÁËlibrary cache pin£¬Æä½á¹¹¸ü¼òµ¥£¬get&setµÄÔ­×Ó²Ù×÷¸ü¿ì½Ý¡£
ËüÏ൱ÓÚ£¬Ã¿¸öchild cursorÏÂÃ涼ÓÐÒ»¸ömutexesÕâÑùµÄ¼òµ¥ÄÚ´æ½á¹¹£¬µ±ÓÐsessionÒªÖ´ÐиÃSQL¶øÐèÒªpin cursor²Ù×÷µÄʱºò£¬sessionÖ»ÐèÒªÒÔsharedģʽsetÕâ¸öÄÚ´æλ+1£¬±íʾsession»ñµÃ¸ÃmutexµÄshared mode lock.¿ÉÒÔÓкܶàsessionͬʱ¾ßÓÐÕâ¸ömutexµÄshared mode lock£»µ«ÔÚͬһʱ¼ä£¬Ö»ÄÜÓÐÒ»¸ösessionÔÚ²Ù×÷Õâ¸ömutext +1»òÕß-1¡£+1 -1µÄ²Ù×÷ÊÇÅÅËüÐÔµÄÔ­×Ó²Ù×÷¡£Èç¹ûÒòΪsession²¢ÐÐÌ«¶à£¬¶øµ¼ÖÂij¸ösessionÔڵȴýÆäËûsessionµÄmutext +1/-1²Ù×÷,Ôò¸ÃsessionÒªµÈ´ýcursor: pin SµÈ´ýʼþ¡£
µ±¿´µ½ÏµÍ³ÓкܶàsessionµÈ´ýcursor: pin SʼþµÄʱºò£¬ÒªÃ´ÊÇCPU²»¹»¿ì£¬ÒªÃ´ÊÇij¸öSQLµÄ²¢ÐÐÖ´ÐдÎÊýÌ«¶àÁ˶øµ¼ÖÂÔÚchild cursorÉϵÄmutex²Ù×÷ÕùÓá£Èç¹ûÊÇCapacityµÄÎÊÌ⣬Ôò¿ÉÒÔÉý¼¶Ó²¼þ¡£Èç¹ûÊÇÒòΪSQLµÄ²¢ÐÐÌ«¶à£¬ÔòҪôÏë°ì·¨½µµÍ¸ÃSQLÖ´ÐдÎÊý£¬ÒªÃ´½«¸ÃSQL¸´ÖƳÉN¸öÆäËüµÄSQL¡£
select /*SQL 1*/object_name from t where object_id=?
select /*SQL 2*/object_name from t where object_id=?
select /*SQL …*/object_name from