RE: formula for # of redo groups

thanks for the replies... i'll bump it up to 3 groups with 3 members. they're at 50M now... probably will leave them at that and see how many switches i get. this does lead me to a question about # of archive files generated. for recovery... is it better/worse to apply more/less archives? how does this affect point-in-time recovery?

thanks
-doug-

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Doug Gernaat Sent: Wednesday, October 11, 2006 1:50 PM To: oracle-l_at_freelists.org
Subject: formula for # of redo groups

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 12 2006 - 09:08:01 CDT