Re: Size of archive logs

Here are a couple of things I think you should try:

1. log_checkpoint_interval=99999999 This is to ensure that only one checkpoint is taken per redo log. The checkpoints would occur at each redo log switch. Oracle recommends this.
2. 512k is much too small for your redo logs. I suggest you increase each redo log to 5m. If they still switch too often, try increasing them to 20m. Oracle says you should attempt to achieve a rate of one redo log switch per hour (but, I have never been able to achieve that - my 20m logs switch about every seven minutes).

I hope this helps. Remember, your mileage may vary :)

Tim

In article <7nlu53$6ca$1_at_nnrp1.deja.com>,   alan_at_prsc.qld.gov.au wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 28 1999 - 08:16:27 CDT