找出产生大量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;