To identify the Largest Archivelog generators


select
s.sid, username,t.used_ublk,t.used_urec from v$transaction t,v$session s where
t.addr=s.taddr
order by 3;
  • April 24, 2012 | 25 views
  • Comments