I would recommend:
- Increase your RAID cahce as large as you can. Some can have as much as
4GB or more of cache, and I would go to the maximum on your array.
- Check your raid settings and make sure you are not on write through,
minimizing the writes from cache.
- Try adding some RAID 1 pairs for temp and undo tablespaces.
- Maximize the memory used by your instance
- Reduce the checkpoint frequency.
- Increase the size of your redo logs.
- If you are running in archive log mode, do not write to the primary array.
Good Luck!
Chris
----------------------------------------------------
Chris Weiss, Blueoak Database Engineering, LLC
http://www.blueoakdb.com
PH: 517-381-9305
CELL: 517-974-5634
eFAX: 801-340-0740
-----Original Message-----
From: j [mailto:oracledba-ezmlmshield-x90212618.[Email address protected]
Sent: Tuesday, September 14, 2004 7:56 AM
To: LazyDBA Discussion
Subject: raid
Dear All,
RAID 5 on client site is causing performance problem. what are the
alternatives to MINIMIZE PERFORMANCE because client is not willing to
remove RAID.
Jay
DISCLAIMER: The information contained in this message is intended only and
solely for the addressed individual or entity indicated in this message and
for the exclusive use of the said addressed individual or entity indicated
in this message (or responsible for delivery
of the message to such person) and may contain legally privileged and
confidential information belonging to Tata Consultancy Services Limited. It
must not be printed, read, copied, disclosed, forwarded, distributed or used
(in whatsoever manner) by any person other than the
addressee. Unauthorized use, disclosure or copying is strictly prohibited
and may constitute unlawful act and can possibly attract legal action, civil
and/or criminal.
The contents of this message need not necessarily reflect or endorse the
views of Tata Consultancy Services Limited
on any subject matter. Any action taken or omitted to be taken based on this
message is entirely at your risk and neither the originator of this message
nor Tata Consultancy Services Limited takes any responsibility or liability
towards the same. Opinions, conclusions and any other
information contained in this message that do not relate to the official
business of Tata Consultancy Services Limited shall be understood as neither
given nor endorsed by Tata Consultancy Services Limited or any affiliate of
Tata Consultancy Services Limited. If you have received this message in
error,
you should destroy this message and may please notify the sender by e-mail.
Thank you.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page