Re: Turn Off Redo Logs?

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: 1998/04/06
Message-ID: <352958B9.5FBDACF2@cc.gatech.edu>#1/1

> The rule of thumb for sizing the redo log is dependent upon how busy your
> oracle database is . You can check your alert log to see how frequent the
> log switch is occuring ..... The switches should not be more frequent that
> 45 minutes ..... It it is more frequent ,(say every 5 minutes) increase the
> size of the redo log ....

I do see in the logs that the redo switch doesn't happen fast enough. Does this mean I need bigger logs, smaller logs, or more of them.

> On the number of redo logs I think four will be a good number , just make
> sure you have
> at least two sets of them .....
>

Two sets, as is two redo logs that each have two members? Why is that? Received on Mon Apr 06 1998 - 00:00:00 CDT