RE: Arch log files sizes

Arch log file sizes do vary depending on when the file was archived. This can happen due to someone issuing an 'alter system switch logfile' or log_checkpoint_interval init parameter. The point is that arch is as lazy as the rest of the background processes and isn't going to write any more than it has to.  

Dick Goulet
Senior Oracle DBA
PAREXEL International
978.313.3426
 information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prabhu, Krishnaswamy Sent: Wednesday, November 12, 2008 9:56 AM To: joel.patterson_at_crowley.com; gnahmed.c_at_stc.com.sa; oracle-l_at_freelists.org
Subject: RE: Arch log files sizes

Sorry for the typo...i mean Oracle release 10.2.0.4 instances..  

Thanks
Prabhu

Subject: RE: Arch log files sizes
Date: Wed, 12 Nov 2008 08:19:25 -0500
From: Joel.Patterson_at_crowley.com
To: gnahmed.c_at_stc.com.sa; prabhu_adam_at_hotmail.com; oracle-l_at_freelists.org

You sure he didn't mean 10.2.0.4 instances?  

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nizar Ahmed Sent: Wednesday, November 12, 2008 5:25 AM To: prabhu_adam_at_hotmail.com; oracle-l_at_freelists.org Subject: RE: Arch log files sizes  

Something's is not right here. 10204 instances - that's fat-fetched.    

G. Nizar A. Baig  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prabhu, Krishnaswamy Sent: Wednesday, November 12, 2008 9:33 AM To: oracle-l_at_freelists.org
Subject: Arch log files sizes  

List,  

We are running 10204 instances, recently the arch log destination got filled up 100% and we noticed few arch logs files sizes are varying, the sizes are twice larger than the average file size, archive_lag_target is set to 0. Can anyone please throw more insight on this.  

Thanks
Prabhu

Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! <http://sports.in.msn.com/>

• Disclaimer: The information in this email and in any files transmitted with it, is intended only for the addressee and may contain confidential and/or privileged material. Access to this email by anyone else is unauthorized. If you receive this in error, please contact the sender immediately and delete the material from any computer. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. Statement and opinions expressed in this e-mail are those of the sender, and do not necessarily reflect those of STC.

  ---

Give the world a slice of your life. Get a Live.in id Check it out! <https://signup.live.com/signup.aspx?mkt=en-in&rollrs=12&lic=1>

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