Archive Log Information

 Size of the archives available on disk

===================================

Select round(sum(BLOCK_SIZE * BLOCKS)/1024/1024/1024,2 ) "Size_of_arc_on_disk_GB"
From v$archived_log
Where status  like 'A';

How many days archives are there on disk and their time info

==========================================================
Select Min(completion_time) "Lowest_arc_found_on_disk",
Max(completion_Time) "Highest_arc_found_on_disk",
Round(max(completion_Time)  - min(completion_time),2) "No_of_Days_Aric_on_disk"
From v$archived_log
Where status  like 'A';

No of archives generated/day, size & freqency

===========================================
Select trunc(completion_time) "Date",
To_char(trunc(completion_time),'Day') "Day",
Count(*) "No_of_arc" ,
Round(1440/count(*),2) "Frquency_arc_created_Min",
Round(sum(block_size * blocks)/1024/1024/1024,2) "Size_disk_GB"
From v$archived_Log
Group by trunc(completion_time)
Order by trunc(completion_time) desc;