RE: Too many archive log

From: <Winnie_Liu_at_infonet.com>
Date: Thu, 26 Oct 2000 13:35:25 -0700
Message-Id: <10661.120350@fatcity.com>

You are right. If the database is not active at all. A 1MB redo log wil= l
take forever to fill. But looking at the rate of the log switch for Lar= ry.
I guess they are suffering a very severe performance problem here.

And I must admit that a 600MB Oracle database is a misery to me... and = yes,
why pay big buck to go for oracle if you only have a tiny database, why=

don't save money with M$ Access? :P

Winnie

Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>@fatcity.com = on
10/26/2000 12:56:07 PM

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: RE: Too many archive log

I did consulting for a company who had an Oracle database that was only=

600MB and they had 1 MB redo logs, which was fine. It all depends on th= e
business requirements. Why they didn't go with Microcrap Access still remains a mystery.

Regards,
Satar

-----Original Message-----
From:=A0=A0 Winnie_Liu_at_infonet.com [SMTP:Winnie_Liu_at_infonet.com] Sent:=A0=A0 Thursday, October 26, 2000 6:57 PM To:=A0=A0=A0=A0 Multiple recipients of list ORACLE-L Subject:=A0=A0=A0=A0=A0=A0=A0 Re: Too many archive log

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:=A0 root_at_fatcity.com

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

cc:

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-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:21 0000091001.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:21 0000091002.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:21 0000091003.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:22 0000091004.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:22 0000091005.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1050112 Oct 23 19=
:22 0000091006.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:22 0000091007.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:23 0000091008.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:23 0000091009.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1052672 Oct 23 19=
:23 0000091010.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:23 0000091011.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056256 Oct 23 19=
:24 0000091012.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:24 0000091013.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 19=
:24 0000091014.arc

-rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 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
   =A0 INET: ltaylor_at_iq.com

Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858) 5= 38-5051

San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- 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).=A0 You ma= y

also send the HELP command for other information (like subscribing).=

   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com    --
   Author:
   =A0 INET: Winnie_Liu_at_infonet.com

Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858) 5= 38-5051

San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- Public Internet access= / Mailing Lists

   --------------------------------------------------------------------=