rgb_rgb的博客

SYSTEM Administrator 17695106 152 639 4601 alter system kill session '639,4601'; 3tk5z3cujb2hn latch: object queue header operation 6.16 SUGUO\VM_DTCCLIENT_ZB VM_DTCCLIENT_ZB DTCClient.exe ACTIVE Oth

原文：http://blog.youkuaiyun.com/launch_225/article/details/7160856 关于enq: TX - index contention 等待的探讨与测试最近生产库上遭遇短时间的enq: TX - index contention 等待，导致数据库hang住：这个等待事件解释如下：Waits for TX in mode 4 als

如果有latch: row cache objects等待事件，那么会导致CPU很高，主机和数据库响应都很慢。和Rowcache及其相关Latch的视图主要有：v$latch_children,v$rowcache.Row cache objects latch用来保护数据字典缓冲区的，进程在装载、引用或者清除数据字典缓冲区中的对象时必须获得该latch。Latch不会造成阻塞，只会导致等待。

0v3sz10tc9kua cursor: pin S wait on X 529.71 WORKGROUP\VM_SHOPMID_10 VM_SHOPMID_10 参考：http://warehouse.itpub.net/post/777/493962http://blog.youkuaiyun.com/tianlesoftware/article/details/6549018

resmgr:cpu quantum

set linesize 200 pages 120select wait_class#,wait_class_id,wait_class,count(*) as "count" from v$event_name group by wait_class#,wait_class_id,wait_class order by wait_class#;WAIT_CLASS# WAIT