Wait event:read by other session

parknkjun發表於2015-05-06
AISession
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

這個等待事件是當一個session在請求一個buffer時，該buffer正被其他session讀入buffer cache，該等待事件在10.1之前被歸到buffer busy wait類，10g之後被分離出來成了read by other session。

根據file#,block#查詢熱塊物件
select segment_name, segment_type, owner, tablespace_name
from dba_extents
where file_id = file#
     and block#
     between block_id and block_id + blocks - 1;

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

相關文章