Re: archive log on

If you increase the size of your online redo log files. It will hold more data in each file. And the archive log files count will decrease.

But at the same time, your size of archive log file will be bigger also.

Winnie

"Salih, Tarig - ASPEN Project" <SalihT_at_ci.denver.co.us> on 05/26/2000 03:15:31 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

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).