Sunday, 30 December 2012

how much archive generate per day

SQL> select to_char(completion_time,'DD/MM/YYYY') HOUR,count(*),round(sum(blocks*block_size)/1024/1024/1024,2) size_g from v$archived_log where completion_time>sysdate-30 group by to_char(completion_time,'DD/MM/YYYY') order by to_char(completion_time,'DD/MM/YYYY') asc;

SQL> show parameter db_recovery_file_dest

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
db_recovery_file_dest                string                           /ora/db001/dbfra001/<db_name>
db_recovery_file_dest_size           big integer                      500G

SQL>!df -h | grep /ora/db001/dbfra001
          2.5T  348G  2.1T  15% /ora/db001/dbfra001

redo logs are located on "/ora/db001/redo001/FPD1AP/" and "/ora/db001/redo002/<db_name>/" ,total 15 redo logfiles with total size 92GB. 

SQL> select sum(bytes)/1024/1024 size_m,count(*) from v$log;

    SIZE_M   COUNT(*)
---------- ----------
     92160         15

SQL> !df -h|grep /ora/db001/redo00
                       99G   91G  8.9G  92% /ora/db001/redo002
                      100G   91G  9.8G  91% /ora/db001/redo001

No comments:

Post a Comment