Message-ID: <4A537711.7040203@lanl.gov>
Date: Tue, 07 Jul 2009 10:25:53 -0600
From: Julio Aguilar-Chang <jachang@lanl.gov>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: Andrew Kerber <andrew.kerber@gmail.com>
CC: jdanton1@yahoo.com, oracle-l@freelists.org
Subject: Re: archivelog performance issues
References: <4A537289.2090102@lanl.gov>	 <582568.13479.qm@web58704.mail.re1.yahoo.com> <ad3aa4c90907070922o1c5d4bf9s84dfe855eb3d2f3c@mail.gmail.com>
In-Reply-To: <ad3aa4c90907070922o1c5d4bf9s84dfe855eb3d2f3c@mail.gmail.com>
Content-Type: multipart/alternative; boundary="------------010506070608080505030007"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: jachang@lanl.gov
--------------010506070608080505030007
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Good point about switching.  I looked at the alert log and it looks like 
the logs switch every 15 - 20 minutes, so they appear to be sized correctly.

Regarding storage, the entire database structure is stored locally on 
the server. 


Andrew Kerber wrote:
> In general, there is very little noticeable impact in running 
> archivelog mode unless your logs are badly undersized and the logs are 
> switching every minute or so.  If the logs are properly sized so that 
> they switch every 15-30 minutes, there will not be a noticeable impact.
>
> On Tue, Jul 7, 2009 at 11:09 AM, Joey D'Antoni <jdanton1@yahoo.com 
> <mailto:jdanton1@yahoo.com>> wrote:
>
>     How is your storage arranged? In general, with a database of that
>     size, I can't imagine a significant performance impact from
>     running in archivelog mode, unless the storage was horribly
>     misconfigured.
>      
>     Joseph D'Antoni
>     Synthes USA
>
>     ------------------------------------------------------------------------
>     *From:* Julio Aguilar-Chang <jachang@lanl.gov
>     <mailto:jachang@lanl.gov>>
>     *To:* Oracle-L Freelists <oracle-l@freelists.org
>     <mailto:oracle-l@freelists.org>>
>     *Sent:* Tuesday, July 7, 2009 12:06:33 PM
>     *Subject:* archivelog performance issues
>
>     Hello:
>     What are the performance issues I should be aware of if I decide
>     to enable archivelog mode on an OLTP database?  I just inherited
>     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 well versed in Oracle) tells me that the previous DBA who
>     just left did not enable archiving for database performance
>     reasons.  The Oracle server is an HP DL385, dual core, with 16GB
>     of memory.
>     Is there a good reason based on performance for not enabling
>     archivelog mode?
>
>     -- 
>     *****************************************
>     Julio Aguilar-Chang
>     Geophysics Group, EES-17
>     Los Alamos National Laboratory
>
>     jachang@lanl.gov <mailto:jachang@lanl.gov>
>     (505) 667-1004 - work
>     (505) 665-3687 - fax
>     *****************************************
>
>     --
>     http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
>
> -- 
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'

-- 

*****************************************
Julio Aguilar-Chang
Geophysics Group, EES-17
Los Alamos National Laboratory

jachang@lanl.gov
(505) 667-1004 - work
(505) 665-3687 - fax
*****************************************


--------------010506070608080505030007
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Good point about switching.&nbsp; I looked at the alert log and it looks
like the logs switch every 15 - 20 minutes, so they appear to be sized
correctly.<br>
<br>
Regarding storage, the entire database structure is stored locally on
the server.&nbsp; <br>
<br>
<br>
Andrew Kerber wrote:
<blockquote
 cite="mid:ad3aa4c90907070922o1c5d4bf9s84dfe855eb3d2f3c@mail.gmail.com"
 type="cite">In general, there is very little noticeable impact in
running archivelog mode unless your logs are badly undersized and the
logs are switching every minute or so.&nbsp; If the logs are properly sized
so that they switch every 15-30 minutes, there will not be a noticeable
impact.<br>
  <br>
  <div class="gmail_quote">On Tue, Jul 7, 2009 at 11:09 AM, Joey
D'Antoni <span dir="ltr">&lt;<a moz-do-not-send="true"
 href="mailto:jdanton1@yahoo.com">jdanton1@yahoo.com</a>&gt;</span>
wrote:<br>
  <blockquote class="gmail_quote"
 style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
    <div>
    <div
 style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">
    <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 archivelog mode, unless the storage was horribly
misconfigured.</div>
    <div>&nbsp;</div>
    <div>Joseph D'Antoni</div>
    <div>Synthes USA<br>
    </div>
    <div
 style="font-size: 10pt; font-family: arial,helvetica,sans-serif;"><br>
    <div
 style="font-size: 13px; font-family: arial,helvetica,sans-serif;"><font
 face="Tahoma" size="2">
    <hr size="1"><b><span style="font-weight: bold;">From:</span></b>
Julio Aguilar-Chang &lt;<a moz-do-not-send="true"
 href="mailto:jachang@lanl.gov" target="_blank">jachang@lanl.gov</a>&gt;<br>
    <b><span style="font-weight: bold;">To:</span></b> Oracle-L
Freelists &lt;<a moz-do-not-send="true"
 href="mailto:oracle-l@freelists.org" target="_blank">oracle-l@freelists.org</a>&gt;<br>
    <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, July
7, 2009 12:06:33 PM<br>
    <b><span style="font-weight: bold;">Subject:</span></b> archivelog
performance issues<br>
    </font>
    <div>
    <div class="h5"><br>
Hello:<br>
What are the performance issues I should be aware of if I decide to
enable archivelog mode on an OLTP database?&nbsp; I just inherited 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 well
versed in Oracle) 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 performance for not enabling archivelog
mode?<br>
    <br>
-- <br>
*****************************************<br>
Julio Aguilar-Chang<br>
Geophysics Group, EES-17<br>
Los Alamos National Laboratory<br>
    <br>
    <a moz-do-not-send="true" href="mailto:jachang@lanl.gov"
 target="_blank">jachang@lanl.gov</a><br>
(505) 667-1004 - work<br>
(505) 665-3687 - fax<br>
*****************************************<br>
    <br>
--<br>
    <a moz-do-not-send="true"
 href="http://www.freelists.org/webpage/oracle-l" target="_blank">http://www.freelists.org/webpage/oracle-l</a><br>
    <br>
    <br>
    </div>
    </div>
    </div>
    </div>
    </div>
    <br>
    </div>
  </blockquote>
  </div>
  <br>
  <br clear="all">
  <br>
-- <br>
Andrew W. Kerber<br>
  <br>
'If at first you dont succeed, dont take up skydiving.'<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">-- 

*****************************************
Julio Aguilar-Chang
Geophysics Group, EES-17
Los Alamos National Laboratory

<a class="moz-txt-link-abbreviated" href="mailto:jachang@lanl.gov">jachang@lanl.gov</a>
(505) 667-1004 - work
(505) 665-3687 - fax
*****************************************
</pre>
</body>
</html>

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