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;
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/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/10271187/viewspace-1624831/
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
