Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: archive log on

RE: archive log on

From: Gurgaon, DBA (CAP, GECSI, CONTRACTOR) <DBA.Gurgaon_at_geind.GE.com>
Date: Mon, 29 May 2000 15:27:38 +0530
Message-Id: <10512.107008@fatcity.com>


Increase the size of your redo log files;

Vikas

-----Original Message-----
From: Salih, Tarig - ASPEN Project [mailto:SalihT_at_ci.denver.co.us] Sent: Saturday, May 27, 2000 3:46 AM
To: Multiple recipients of list ORACLE-L Subject: archive log on

Hi Gurus,
I turned archive log on 2 days ago, I have script running via cronjob that do a log switch every hour, that mean I suppose to get an archive log file each hour. The problem is, I am getting too many archive log files in the archive log dest. 20 archive files/hour How could I cut the number of the archive log files generated. We are using
Oracle 7.3.4.00
on Aix 4.3
redo log size 10M
log_checkpoint_interval= 20000
log_buffer=8192
db_block_buffer=550

-- 
Author: Salih, Tarig - ASPEN Project
  INET: SalihT_at_ci.denver.co.us

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 Mon May 29 2000 - 04:57:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US