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

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Fri, 21 Jun 2013 17:02:09 +0530
Message-ID: <CAABGLuLrNO8USEciBObSuw5swJTAKJEGvucvTZwM_HM1_ruADQ_at_mail.gmail.com>

Bala,
Should be the same in size, Do you think compression is enabled in any case(my suspect but not sure, lets see)?
> SQL> select dest_id,compression from v$archive_dest;

For that i also tested and i can see same size of archives from database and also from OS level.

TIME                   SIZE_MB
------------------- ----------

2013-06-19 00:00:00 13706.312
2013-06-20 00:00:00 13445.0024
*2013-06-21 00:00:00 4407.10303*

47 rows selected.

SQL> $ ls -l o1_mf_1* | grep "Jun 21" | awk '{ SUM += $5} END { print SUM/1024/1024 }'
*4407.13*
$

Thanks & Regards,
Nassyam Basha.
www.oracle-ckpt.com

On Fri, Jun 21, 2013 at 4:51 PM, Bala Krishna <krishna000_at_gmail.com> wrote:

> 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
>
>
>

-- 
Thanks & Regards,
Nassyam Basha.


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 21 2013 - 13:32:09 CEST