RE: Arch log files sizes
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <prabhu_adam@xxxxxxxxxxx>, <joel.patterson@xxxxxxxxxxx>, <gnahmed.c@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 Nov 2008 12:28:24 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Prabhu, Krishnaswamy
Sent: Wednesday, November 12, 2008 9:56 AM
To: joel.patterson@xxxxxxxxxxx; gnahmed.c@xxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx
To: gnahmed.c@xxxxxxxxxx; prabhu_adam@xxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
You sure he didn't mean 10.2.0.4 instances?
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nizar Ahmed
Sent: Wednesday, November 12, 2008 5:25 AM
To: prabhu_adam@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Prabhu, Krishnaswamy
Sent: Wednesday, November 12, 2008 9:33 AM
To: oracle-l@xxxxxxxxxxxxx
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>
Other related posts:
