Thursday, November 12, 2015
Find Total archive generated with Size - day wise
/* Script to find total number of archives generated with the size per day */
select to_char(COMPLETION_TIME,'DD/MON/YYYY') Day,
count(sequence#) "Total Archives"
from (select distinct sequence#,
group by to_char(COMPLETION_TIME,'DD/MON/YYYY')
order by 1;