Re: Turn Off Redo Logs?

Paul Bennett wrote:
>
> > 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.

Smaller (when the log switch occurs every 2 hours)

>
> > 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?

The members of a group are mirrors of each other (for security, keep them on
different disc, so when one crashes you still have one left). Oracle writes in circle into the diffrent groups (e.g. first group 1, then group 2
and so on). If your DB is in archive mode you need at least 2 groups (one is written
to and the other is archived).
rgds
eugen Received on Tue Apr 07 1998 - 00:00:00 CDT