本文共 765 字,大约阅读时间需要 2 分钟。
enqueue
[@more@]enqueue
The wait event is related to transaction locking.
1. Discover the requested lock type and mode by deciphering the P1 value supplied by the CURRENT_EVENT cursor.
2. Determine the name of the object the enqueue is for using the ROW_WAIT_OBJ# supplied by the CURRENT_EVENT cursor:
3. Identify the blocking session and the information about the lock that is being held, such as the lock type and lock mode and time held using the P2 and P3 values supplied by the CURRENT_EVENT cursor:
4. Obtain the SQL statement that is associated with the event using the hash value supplied by the CURRENT_EVENT cursor:
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/178357/viewspace-896952/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/178357/viewspace-896952/
转载地址:https://blog.csdn.net/cizhuima2286/article/details/100411593 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!