SQL> select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME) order by 1; TIME SIZE_MB --------------- ---------- 14-JUN-13 4686.66113 15-JUN-13 5034.78223 16-JUN-13 13200.043 17-JUN-13 28354.2949 18-JUN-13 41484.9424 19-JUN-13 106919.205 20-JUN-13 333374.683 21-JUN-13 33958.165 bash-3.2$ ls -l arch* | grep "Jun 21" | awk '{ SUM += $5} END { print SUM/1024/1024 }' 16979.1 for 21st June it shows 33958 MB as size from V$archived_log but where as at OS level it shows 16979.1, what am i missing here ? and there is almost a big diference that i can see for each and every day from the above output. -- //www.freelists.org/webpage/oracle-l