Re: Archive log files reaches maxloghistory

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Mon, 10 Nov 2003 13:01:02 +1100
Message-ID: <3faef16d$0$9913$afc38c87@news.optusnet.com.au>

"Peter" <peter_at_nomorenewspamin.ca> wrote in message news:skotqvoanclaph59e2bae702eijnd7hfhr_at_4ax.com...
> On Sat, 25 Oct 2003 12:13:11 -0500, Brian Peasland
> <dba_at_remove_spam.peasland.com> wrote:
>
> I original set the maxloghistory to 500 but now it has expanded to 900
> within 7 days, thanks to CONTROL_FILE_RECORD_KEEP_TIME = 7 days
> Now I am considering resetting CONTROL_FILE_RECORD_KEEP_TIME to a
> smaller number.

900 archives in 7 days means you are producing 128 archives per day. That's 128 log switches per day, or about 6 switches per hour. That's one every 10 minutes.

I'd be increasing the size of your online logs if I were you. Log switches are big events in the life of the database, with lots of I/O going on, etc etc. Best not to be switching (generally speaking) more than about once every half hour or so, worst case.

Of course, if you've already got Gigabyte-sized logs and are still switching at this rate, it very much becomes 'the nature of the beast' and you learn to live with it. But I'd be looking at log sizes first and worrying about control_file_record_keep_time a distant second.

Regards
HJR Received on Sun Nov 09 2003 - 20:01:02 CST