Archive file generation each of different size

General suggestions and comments about the forums.

Moderator: Tim...

Archive file generation each of different size

Postby Raaj A » Tue Feb 12, 2013 11:29 am

Hi Tim,

I have created my newly production database on oracle(11.2.0.1.0) on windows 2008 R2.I have kept redo log file size 50mb. but every archive file is creating of different sizes. for e.g. 30mb..20mb..10mb..25mb. However in other databases the size of archive file is mostly same around 45mb each.

Please suggest the cause of this different size of arc log file.

Please help..


Thanks
Raaj
Raaj A
Member
 
Posts: 49
Joined: Wed Mar 07, 2012 7:08 am

Re: Archive file generation each of different size

Postby Tim... » Tue Feb 12, 2013 11:57 am

Hi.

I only know of two reasons for this:

1) You are doing a manual log switch before the file is full.
2) You are using a timeout (archive_lag_target) to switch after so many minutes, regardless of how full the file is.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17957
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Suggestions and Comments

Who is online

Users browsing this forum: No registered users and 1 guest