Archive log file sizes at OS is different from i get the values.

From: Bala Krishna <krishna000_at_gmail.com>
Date: Fri, 21 Jun 2013 16:51:18 +0530
Message-ID: <CAG+FZagMzN50GFLp_9+TZY425T0u29tbAJrRETEv2pFiz1tYpA_at_mail.gmail.com>

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.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 21 2013 - 13:21:18 CEST