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

Home -> Community -> Usenet -> c.d.o.server -> Re: Size of archive logs

Re: Size of archive logs

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Wed, 28 Jul 1999 10:10:01 +0100
Message-ID: <7nmhdc$dp7$1@taliesin.netcom.net.uk>


The size of each file should be the same size as a redo log. Are your redo logs this small ? They will be smaller if a 'switch logfile ' command is issued. Checkout the Oracle8 Backup and Recovery Guide for more info.

Alex

alan_at_prsc.qld.gov.au wrote in message <7nlu53$6ca$1_at_nnrp1.deja.com>...
>Are there any parameters to tune the size and frequency of the archive
>log files?
>
>My LOG_ARCHIVE_DEST fills up with about 1Gb of archive log files in two
>days. The files are approx 512K in size and Oracle generates a couple
>every minute.
>
>The database is only about 1Gb with a small number of users running a
>financial system. I assume that they would not be generating 500Mb of
>changes a day.
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Jul 28 1999 - 04:10:01 CDT

Original text of this message

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