【效能調整】等待事件read by other session
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
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能力不行,或者負荷太大
10g開始從buffer busy wait中分離出來,其實也是熱快的一種情況
大多數原因是sql的物理讀太大,同時儲存的io能力不行,或者負荷太大
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16179598/viewspace-749249/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- read by other session等待事件Session事件
- 等待事件:read by other session事件Session
- 【等待事件】read by other session事件Session
- read by other session 等待事件分析Session事件
- 關於等待事件"read by other session"事件Session
- read by other session等待事件模擬Session事件
- 【TUNE_ORACLE】等待事件之IO等待“read by other session”Oracle事件Session
- 等待模擬-read by other sessionSession
- 等待事件_buffer_busy_waits_and_read_by_other_session(1)事件AISession
- 等待事件_buffer_busy_waits_and_read_by_other_session(2)事件AISession
- 等待事件_buffer_busy_waits_and_read_by_other_session(3)事件AISession
- 等待事件_buffer_busy_waits_and_read_by_other_session(4)事件AISession
- 【效能調整】等待事件(六) direct path read&write事件
- 【效能調整】等待事件(一)事件
- 【效能調整】等待事件(二)事件
- 【效能調整】等待事件(三) 常見等待事件(一)事件
- 【效能調整】等待事件(四) 常見等待事件(二)事件
- 【效能調整】等待事件(五)log相關等待事件
- 【效能調整】等待事件(九) latch原理事件
- 【效能調整】等待事件 enq: SQ - contention事件ENQ
- Oracle Dba必須瞭解的Read By Other Session等待:OracleSession
- 【效能調整】等待事件(十) 10g中的latch等待事件
- read by other session 測試Session
- 【效能調整】等待事件(七) io相關等待查詢指令碼事件指令碼
- Wait event:read by other sessionAISession
- read by other session在undo所想Session
- 【效能調整】等待事件(八) library cache locks and pins事件
- Buffer busy waits/read by other sessionAISession
- read by other session的優化記錄Session優化
- direct path read/read temp等待事件事件
- db file scattered read等待事件事件
- db file sequential read等待事件事件
- 【等待事件】db file sequential read事件
- 【等待事件】db file scattered read事件
- 【TUNE_ORACLE】等待事件之IO等待“direct path read”Oracle事件
- cell single block physical read等待事件BloC事件
- 詳解 db file sequential read 等待事件事件
- control file sequential read等待事件事件