找出产生大量REDO的会话
?
有两中方法:
?
1、查询v$sess_io
SELECT s.sid, s.serial#, s.username, s.program,i.block_changes
FROM v$session s, v$sess_io i
WHERE s.sid = i.sid
ORDER BY 5 desc;
2、查询v$transaction
SELECT s.sid, s.serial#, s.username, s.program,t.used_ublk, t.used_urec FROM v$session s, v$transaction t WHERE s.taddr = t.addr ORDER BY 5 desc, 6 desc;
