| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: San Performance gurus--performance experiences on San
Guys, I appreciate the performance experiences on Oracle on San.
Brian
-----Original Message-----
Sent: Thursday, April 24, 2003 3:28 PM
To: Multiple recipients of list ORACLE-L
Sarnowski, Chris wrote:
> > We've got a Hitachi 9960, and have done all of our striping at > the hardware level. The database is sharing the same disks as > several large flat-file systems (e.g. Genbank databases used > for BLAST). We're using Veritas, but not using it to do any > RAID or striping. We're using Quick I/O for the DB but I'm > not convinced that it makes much of a difference in our > environment.
We are using a Sun branded Hitachi 9970 with veritas. The san presents 30 luns(disks) to the sun host. The Datawarehouse load was going slower than we had hoped on the new hardware. Sun professional services said to use veritas striping across the 30 logical luns. It made a world of difference once we did this. I'm not sure how the disks are set up on the san, but I know there are only 18 physical disks in raid 5 I believe. Not using quick/io, but the newer ODM that comes with the latest version of veritad database edition. I'm not sure how it compares to quickio.
> > I can't tell you much about the actual setup (stripe width, > write cache, etc). I just know that back in the days when I > was SA/DBA, and the database sat on 5 or 6 different > volumes (each a separate RAID set), I had to juggle files to > reduce disk contention, and it was a big pain. Now I don't, > and neither does the current SA. We've both got plenty of other > work to do. > > >
> > > > LEGAL NOTICE: > Unless expressly stated otherwise, this message is confidential and may beprivileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.
-- /************************************************************ * Brian Haas bhaas_at_musiciansfriend.com * * Database Administrator Musician's Friend, Inc. * * Phone:(541)774-5211 http://www.musiciansfriend.com * ************************************************************/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Haas INET: bhaas_at_musiciansfriend.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Spears, Brian INET: BSpears_at_Limitedbrands.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Apr 24 2003 - 17:28:04 CDT
 |
 |