DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, April 24, 2012

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;

No comments: