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')
/
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