RE: archive log on

Try adding new logfiles using much larger sizes. Once you switch onto the new ones and the old ones have been archived, you can drop them and recreate those (if you wish) using a larger size.

HTH,
James

-----Original Message-----
From: Salih, Tarig - ASPEN Project [mailto:SalihT_at_ci.denver.co.us] Sent: Friday, May 26, 2000 3:16 PM
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)...