Re: big variance of archive log file size Oracle 8.1.6

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 21 Sep 2000 08:49:27 -0400
Message-Id: <10626.117559@fatcity.com>

Is your check point interval to small causing the log to switch and = archive the log?
ROR =AA=BF=AA
>>> tszecsy_at_GEOMETRIA.hu 09/21/00 05:55AM >>>
Hi,

I am using Oracle 8iR2 on WinNT in archive log mode. There's a job which enforces logswitch every 5 minutes. It would take some time to explain why this is necessary, but we can not change this. The funny thing about this is, that although data flow is VERY low, hardy 20-30 records change in = this
time gap, still archived log file size vary between 64kB and 1 MB?=20

Dose some one have an idea, what may cause this big variance in file = size?=20

TIA, Tamas Szecsy
Geometria GIS Systems House Ltd.
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Szecsy Tamas
INET: tszecsy_at_GEOMETRIA.hu=20

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 Sep 21 2000 - 07:49:27 CDT