Re: formula for # of redo groups

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: dag@xxxxxxxxxxxxxxx
  • Date: Wed, 11 Oct 2006 22:13:26 +0100

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

On 10/11/06, Doug Gernaat <dag@xxxxxxxxxxxxxxx> 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-
--
//www.freelists.org/webpage/oracle-l





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

Other related posts: