查看数据库发现大量 read by other session [@more@]

这个是 10g 对 buffer busy wait 事件的细分后的一个事件

1 查看当前session

select sid,serial#,logon_time,username,program,machine,event from v$session
where wait_class <> 'Idle'
order by logon_time desc

2 查询出现问题的对象id

SELECT p1 "file#", p2 "block#", p3 "class#"
FROM v$session_wait
WHERE event = 'read by other session';

3 查询对象

SELECT relative_fno, owner, segment_name, segment_type
FROM dba_extents
WHERE file_id = &file
AND &block BETWEEN block_id AND block_id + blocks - 1

输入查询到的对象 id 与块id

ITPub博客

read by other session 等待事件