oracle 案例
-
编辑 删除
read by other session 等待事件
查看数据库 发现大量 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_
