Re: Turn Off Redo Logs?

On Mon, 06 Apr 1998 18:35:38 -0400, Paul Bennett <bennett_at_cc.gatech.edu> 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.

If your alert file claims some 'Could not alocate redo log' then increase the number of your redos (groups).

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

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de