Archive Redo Log File Size & Rman Backup File Size

-- Archive Redo Log File Size
select to_char(completion_time,'YYYYMMDD') "일별 사용량", round(sum(blocks * block_size/1024/1024/1024),1)GB
from V$archived_log
where completion_time>=to_date('20120701','YYYYMMDD')
group by to_char(completion_time,'YYYYMMDD')
order by 1

-- Rman Backup File Size
select to_char(completion_time,'YYYYMMDD') "백업 일자", round(sum(bytes/1024/1024/1024),1)GB
from v$backup_piece
where completion_time > to_date('20120101','YYYYMMDD')
group by to_char(completion_time,'YYYYMMDD')
order by 1