Query to Find the session creating more redo

Query to Find the session creating more redo 


set pages 1000 lines 1000
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;

  • September 27, 2018 | 18 views
  • Comments