Re: tuning redo logs

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Fri, 15 Jan 1999 15:06:13 GMT
Message-ID: <369f560d.476508202@news.cyberus.ca>

This is sometimes difficult to determine. It depends alot on the type of transactions and workload on the system.. What I often encounter are systems that switch log files twice a day and then the next day 60 times.... How do you tune these environments, well, it's not easy.

.... I would suggest you aim to have logs switch every 20 minutes or so during your peak periods...Beware of batch updates...

So... If you have 10meg redo-logs now and during peak times they are switching every 4 minutes, you may want to try 40 megs...

Good Luck,

Robert Prendin

"Osvaldo Robles" <orobles1_at_coqui.ney> wrote:

>Hi everyone
> I would like to know if there is a formula or a method to determine the
>number of redo logs necessary for a database that handles about 16 million
>records.
>
>thanks in advance
>
>

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Fri Jan 15 1999 - 09:06:13 CST