Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: big variance of archive log file size Oracle 8.1.6
No. Actually a job is forcing the log switch every 5 minutes, to =
minimize
data loss in case of disaster. It's a primary-standby configuration, =
but the
client did not have licence for Enterprise Oracle. So managed standby
database was not an option and we had to imitate it.
Tamas
-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org]
Sent: Thursday, September 21, 2000 3:52 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: big variance of archive log file size Oracle 8.1.6
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).
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Ron Rogers
INET: RROGERS_at_galottery.org
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 Sep 22 2000 - 03:14:17 CDT
![]() |
![]() |