本文共 672 字,大约阅读时间需要 2 分钟。
library cache pin
[@more@]The library cache pin wait event is related to contention for library cache objects.
1. Look up the name of the object that the pin is for using the P1RAW value supplied by the CURRENT_EVENT cursor:
2. Find out who is blocking, the statement that is executing, and the mode in which the object is being held using the P1RAW value supplied by the CURRENT_EVENT cursor:
3. Obtain the SQL statement that is associated with the library cache pin event using the hash value supplied by the CURRENT_EVENT cursor:
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/178357/viewspace-896954/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/178357/viewspace-896954/
转载地址:https://blog.csdn.net/cizhuima2286/article/details/100411595 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!