本文共 850 字，大约阅读时间需要 2 分钟。
buffer busy waits
[@more@]The buffer busy waits event is related to read/read, read/write, and write/write contention.
1. Establish the name of the object that the buffer lock contention is for using the P1 and P2 values supplied by the CURRENT_EVENT cursor:
3. Find out the type of block using the P1 and P2 values provided by the CURRENT_EVENT cursor. The contention may be for a segment header block, freelist group block, or data block. In Oracle Database 10g, this information is provided by the P3 parameter. See the “buffer busy waits” section in for more details.
4. Obtain the SQL statement that is associated with the buffer busy waits event using the hash value supplied by the CURRENT_EVENT cursor:
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/178357/viewspace-896953/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/178357/viewspace-896953/
转载地址：https://blog.csdn.net/cizhuima2286/article/details/100411597 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！
发表评论
最新留言
关于作者
