Alter Session Set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';
Select substr(lg.COMPLETION_TIME,1,10) As "Date",sum(lg.BLOCKS*lg.BLOCK_SIZE) As "sumbyte" ,
Sum(lg.SEQUENCE#) lgnum From v$archived_log lg
Where substr(lg.COMPLETION_TIME,1,10)> Sysdate -7
Group By substr(lg.COMPLETION_TIME,1,10);
|