archived logs

From: Joseph David Paparo <>
Date: Tue, 16 Apr 2013 13:38:53 +0000
Message-ID: <>

I am trying to find the total size of our accumulated backup archived logs. Does anyone have any idea how I can get this information? I found this query on an oracle forum but I wanted to see anyone else has any other information.

select round(sum(blocks*block_size)/1024/1024/1024) arc_size, trunc(first_time) arc_date from v$archived_log where dest_id=1 group by trunc(first_time) order by 2 desc;

Received on Tue Apr 16 2013 - 15:38:53 CEST

Original text of this message