Tuesday, July 29, 2014

Query to find archival size generated each day

select sum(blocks*block_size)/1048576 "archsize MB", to_char(COMPLETION_TIME, 'DD-Mon') date1
from v$archived_log
group by to_char(COMPLETION_TIME, 'DD-Mon')
order by to_char(COMPLETION_TIME, 'DD-Mon')
/

No comments:

Post a Comment