library cache lock buffer busy waits row cache lock log file sync log file switch completion db file scattered read enq:TX-row lock contention db file sequential read cachee buffer LRU chain latch |
vage 发表于 2013-9-10 15:10
还有Mutex类等待。
Latch相关的还有Cache buffers chain latch、Shared Pool Latch也很重要,一个对应逻辑 ...
wailon 发表于 2013-9-10 15:30
楼主把大部分常见的都说了,log file switch(checkpoint incomplete),可能的原因,频繁提交,REDO日志过小, ...
欢迎光临 ITPUB论坛-专业的IT技术社区 (http://www.itpub.net/) | Powered by Discuz! X3.2 |