Re: Too many archive log

From: <Winnie_Liu_at_infonet.com>
Date: Thu, 26 Oct 2000 09:56:51 -0700
Message-Id: <10661.120305@fatcity.com>

Gee.. 1MB redolog file is WAY too small!! You should definitely increased the size of the redo log.

It is very costly for Oracle to do the log switch. You would want to have it doing a switch about every 30 minutes only. You will have less archivelog this way, but the size of the logs will be bigger.

Winnie

Larry Taylor <ltaylor_at_iq.com>@fatcity.com on 10/26/2000 10:25:28 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: Too many archive log

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 Thu Oct 26 2000 - 11:56:51 CDT