Re: formula for # of redo groups

one more than you currently have. and a larger (or sometimes very much smaller) size.

On 10/11/06, Doug Gernaat <dag_at_its.msstate.edu> wrote:
>
> is there a tried and true formula for deciding on the number
> or redo groups and members? is the decision solely based on
> LGWR activity? what about archiving? for example... a
> database with 2 groups and 2 members in each group that
> switches about 10 times a day producing 10 archive files.
> what is optimal in a relative world?
>
> thanks
> -doug-
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l