DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws;  s=s1024; d=yahoo.com;  h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;  b=iwSH5SyON3PzPhhQREeTzahFTag58WfOxpFHNv8/N7HYvn7f4A7wlQWN80yEDFnZ6Htc8ZO4IvDx3jnreSXDJfcRJG76ZcBovFbKP3WruII/S9tODJ9AtD0orXTsXXlDA5Yk/YNpuGMbZcnXSisFPV9Jdn+le/BAXbJBA/auvi0=;
Message-ID: <582568.13479.qm@web58704.mail.re1.yahoo.com>
References: <4A537289.2090102@lanl.gov>
Date: Tue, 7 Jul 2009 09:09:17 -0700 (PDT)
From: Joey D'Antoni <jdanton1@yahoo.com>
Subject: Re: archivelog performance issues
To: jachang@lanl.gov, oracle-l@freelists.org
In-Reply-To: <4A537289.2090102@lanl.gov>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-640032134-1246982957=:13479"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: jdanton1@yahoo.com
--0-640032134-1246982957=:13479
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

How is your storage arranged? In general, with a database of that size, I c=
an't imagine a significant performance impact from running in archivelog mo=
de, unless the storage was horribly misconfigured.=0A=0AJoseph D'Antoni=0AS=
ynthes USA=0A=0A=0A=0A=0A________________________________=0AFrom: Julio Agu=
ilar-Chang <jachang@lanl.gov>=0ATo: Oracle-L Freelists <oracle-l@freelists.=
org>=0ASent: Tuesday, July 7, 2009 12:06:33 PM=0ASubject: archivelog perfor=
mance issues=0A=0AHello:=0AWhat are the performance issues I should be awar=
e of if I decide to enable archivelog mode on an OLTP database?=A0 I just i=
nherited this database (about 40GB in size, ~200 users, ~2000 transactions =
per day), it is not in archivelog mode, and the manager who owns it (not we=
ll versed in Oracle) tells me that the previous DBA who just left did not e=
nable archiving for database performance reasons.=A0 The Oracle server is a=
n HP DL385, dual core, with 16GB of memory. =0AIs there a good reason based=
 on performance for not enabling archivelog mode?=0A=0A-- =0A**************=
***************************=0AJulio Aguilar-Chang=0AGeophysics Group, EES-1=
7=0ALos Alamos National Laboratory=0A=0Ajachang@lanl.gov=0A(505) 667-1004 -=
 work=0A(505) 665-3687 - fax=0A*****************************************=0A=
=0A--=0Ahttp://www.freelists.org/webpage/oracle-l=0A=0A=0A      
--0-640032134-1246982957=:13479
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:arial, helvetica, sans-serif;font-size:1=
0pt"><DIV>How is your storage arranged? In general, with a database of that=
 size, I can't imagine a significant performance impact from running in arc=
hivelog mode, unless the storage was horribly misconfigured.</DIV>=0A<DIV>&=
nbsp;</DIV>=0A<DIV>Joseph D'Antoni</DIV>=0A<DIV>Synthes USA<BR></DIV>=0A<DI=
V style=3D"FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR>=
=0A<DIV style=3D"FONT-SIZE: 13px; FONT-FAMILY: arial, helvetica, sans-serif=
"><FONT face=3DTahoma size=3D2>=0A<HR SIZE=3D1>=0A<B><SPAN style=3D"FONT-WE=
IGHT: bold">From:</SPAN></B> Julio Aguilar-Chang &lt;jachang@lanl.gov&gt;<B=
R><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> Oracle-L Freelists &l=
t;oracle-l@freelists.org&gt;<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:<=
/SPAN></B> Tuesday, July 7, 2009 12:06:33 PM<BR><B><SPAN style=3D"FONT-WEIG=
HT: bold">Subject:</SPAN></B> archivelog performance issues<BR></FONT><BR>H=
ello:<BR>What are the performance issues I should be aware of if I decide t=
o enable archivelog mode on an OLTP database?&nbsp; I just inherited this d=
atabase (about 40GB in size, ~200 users, ~2000 transactions per day), it is=
 not in archivelog mode, and the manager who owns it (not well versed in Or=
acle) tells me that the previous DBA who just left did not enable archiving=
 for database performance reasons.&nbsp; The Oracle server is an HP DL385, =
dual core, with 16GB of memory. <BR>Is there a good reason based on perform=
ance for not enabling archivelog mode?<BR><BR>--
 <BR>*****************************************<BR>Julio Aguilar-Chang<BR>Ge=
ophysics Group, EES-17<BR>Los Alamos National Laboratory<BR><BR><A href=3D"=
mailto:jachang@lanl.gov" ymailto=3D"mailto:jachang@lanl.gov">jachang@lanl.g=
ov</A><BR>(505) 667-1004 - work<BR>(505) 665-3687 - fax<BR>****************=
*************************<BR><BR>--<BR>http://www.freelists.org/webpage/ora=
cle-l<BR><BR><BR></DIV></DIV></div><br>=0A=0A      </body></html>
--0-640032134-1246982957=:13479--

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