@DBA_白老大

通过视图查历史等待事件

latch:cache buffers chains等待事件导致的latch争用的原理原因与检查

Oracle锁-OWI体系中的认识

db file sequential readThe db file sequential read wait event has three parameters: file#, first block#, and block count. In Oracle Database 10g, this wait event falls under the User I/O wait class. Keep the following key thoughts in mind when dealing wi

db file scattered readThe db file scattered read wait event has three parameters: file#, first block#, and block count. In Oracle Database 10g, this wait event falls under the User I/O wait class.

latch: library cache等待（只存在于9i,10g) SQL->ASCII->Hash_value值->hash bucket，然后申请保护该bucket的library cache latch（3-67个latch保护成千上万个hash bucket)，这个latch是为了保护会话在检索bucket对应的hash chain的过程中，hash chain结构不被改变。 在chain上会挂着一串父cursor头的指针，每检索到一个指针，就到所指向的内存区，去看这个父cursor是否符合（s

Free buffer waits 等待事件总结

buffer lock 引起的buffer cache上的等待事件一个会话想要读或者写位于buffer cache上的块,就必须先获得cache buffers chains latch,然后扫描整条chain上的块头,直到找到适合的块头为止。这个过程中，别的会话就不能再获得cache buffers chains latch了，而必须等待latch:cache buffers chains等待事件。而这些hash latch,hash bucket,hash chain,buffer header，都是