Hi all,

Is it necessary to have 4 log groups with 2 log members in each group for
a database of size 4G in a RAC environment or can we reduce it to 3 groups

Is if sufficient to have a log file of size 100MB.
Please suggest.

Thanks.


Kind regards,
Raj






"olm" <olm.[Email address protected]
03/29/2007 12:41 PM

To
KIDAMBI.[Email address protected]
cc

Subject
Re: Log file parallel writes






**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text




distributing the redo logs between the filesystems definitely have good
results. Increase the size if you have more transaction may be to 150M an
also increase the log groups to 5 - 6. But placing them on a different
filesystem other than your dbf files and system tbs will have good
results.

Try this

Srinivas

This e-mail and any files transmitted with it are for the sole use of the
intended
recipient(s) and may contain confidential and privileged information. If
you are
not the intended recipient, please contact the sender by reply e-mail and
destroy
all copies and the original message. Any unauthorized review, use,
disclosure,
dissemination, forwarding, printing or copying of this email or any action
taken
in reliance on this e-mail is strictly prohibited and may be unlawful.The
recipient
acknowledges that Bharti Airtel Limited or its subsidiaries and associated
companies(collectively "Bharti Airtel Limited"),

are unable to exercise control or ensure or guarantee the integrity
of/overthe contents
of the information contained in e-mail transmissions and further
acknowledges that any views
expressed in this message are those of the individual sender and no
binding nature of the
message shall be implied or assumed unless the sender does so expressly
with due authority of Bharti Airtel Limited.
Before opening any attachments please check them for viruses and defects.




This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.

Visit us at http://www.polaris.co.in

Oracle LazyDBA home page