Re: Too many archive log

From: Suhen Pather <PatherS5_at_telkom.co.za>
Date: Fri, 27 Oct 2000 08:49:11 +0200
Message-Id: <10661.120390@fatcity.com>

Hi Larry

Try to increase the size of your online redo logfiles. 1meg is a bit too small. Your online redo logs are going to switch pretty fast since you have a very busy system. There will be lots of checkpointing since you have such small redologs.
Increase the size of your online redologs to maybe 20meg. Keep a days worth of archives and more if you have the disk space.

HTH
Suhen

>>> ltaylor_at_iq.com 10/26/00 07:25PM >>>
Hi all,

My database has 2 redo log groups and each group has 3 members. Each members size is 1 meg each.

The problem is that archive logs are generated at a fast rate:

-rw-r----- 1 oracle dba 1056768 Oct 23 19:21 0000091001.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:21 0000091002.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:21 0000091003.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:22 0000091004.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:22 0000091005.arc
-rw-r----- 1 oracle dba 1050112 Oct 23 19:22 0000091006.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:22 0000091007.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:23 0000091008.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:23 0000091009.arc
-rw-r----- 1 oracle dba 1052672 Oct 23 19:23 0000091010.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:23 0000091011.arc
-rw-r----- 1 oracle dba 1056256 Oct 23 19:24 0000091012.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:24 0000091013.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:24 0000091014.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:24 0000091015.arc

Isnt it good practice to keep 3 days worth of archive logs on disk in case needed? If so, what is the best solutions for this high rate logs being generated so often?

Thanks in advance.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Larry Taylor
  INET: ltaylor_at_iq.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 27 2000 - 01:49:11 CDT