【效能調整】等待事件read by other session

yellowlee發表於2012-11-15
read by other session
This event occurs when a session requests a buffer that is currently being read into the buffer cache
by another session. Prior to release 10.1, waits for this event were grouped with the other
reasons for waiting for buffers under the ‘buffer busy wait’ event
這個等待一般會和其他等待一同出現,比如db file sequential read
10g開始從buffer busy wait中分離出來,其實也是熱快的一種情況
大多數原因是sql的物理讀太大,同時儲存的io能力不行,或者負荷太大
 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16179598/viewspace-749249/,如需轉載,請註明出處,否則將追究法律責任。

相關文章