| 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: DISK configuration - help please.
If you want to see really interesting results (especially if you are using
hardware RAID with a caching controller), you want to do enough writes to
saturate the cache. The memory on most of today's controllers will allow
the writes to maintain a decent performance rate until that memory fills up
(and then you will really pay the price). On another note, the thing that
caught my attention on Rivaldi's little benchmark was that it looked like he
was comparing data striped across _five_ disks versus data striped across
_three_ disks...2¢ off to the ether (still trying to contribute to the list
even though work has gotten really busy).
Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
LoughMiller, Gregory
Sent: Monday, August 21, 2000 8:35 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: DISK configuration - help please.
Can you try a couple of other benchmarks for the three disk configurations that you mention??
Lets see what the results are from those two benchmarks.. They may prove to be interesting... Granted there are a lot of other variables.....
Greg
-----Original Message-----
Sent: Friday, August 18, 2000 3:27 PM
To: Multiple recipients of list ORACLE-L
I have done benchmarking for full table scan (select count(*) from tablename
So, why dont you use Raid5....?
Rivaldi
>----- Original Message -----
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Sent: Thursday, August 17, 2000 11:14 AM
>
>
> > Get rid of RAID 5.
> >
> > Lyall
> >
> > At 06:46 AM 8/17/00 -0800, you wrote:
> >
> > >I am in the process of building two DB servers - one live and the other
> > >standby. We are not overly concerned with disk capacity - but rather
>with
> > >speed of access.
> > >
> > >Our current configuration is
> > >
> > >primary has 10 disks in RAID 0+1
> > >standby has 6 disks in RAID 5
> > >
> > >This is to give us 5 physical devices for production - I think a
>holdover
>of
> > >OFA guidelines.
> > >
> > >What I am looking for is a bit of advice on the best optin for current
> > >configurations. I can add disks to this later. I am also using
>Veritas
>VM
> > >and FS and so can relayout my RAID 5 to RAID 0+1 pretty easily as well.
> > >Adding disks to the system is also a breaze.
> > >
> > >All of these disks are in one FS mounted to /u01 .. .for easy
>management
>on
> > >our site we elected one mount point and one very expandable FS.
> > >
> > >I am considering breaking my configuration and going with 8 disks in
>0+1
>for
> > >both systems - or going with 10 and 6 but both in 0+1 - I don't think
>that
> > >RAID 5 is a good idea ever - even for a standby system, but there is
>some
> > >pressure to have 5 physical devices and RAID 5 with 6 gives us that
>too...
> > >
> > >
> > >Anybody out there willing to throw two cents my way?
> > >
> > >
> > >thanks!
> > >
> > >adam
> > >--
> > >Author: Adam Turner
> > > INET: ATurner_at_concretemedia.com
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >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).
> >
> > --
> > Author: Lyall Barbour
> > INET: lbarbour_at_stanford.edu
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> >
>
>--
>Author: Steve McClure
> INET: steve_at_pactr.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
>
>--
>Author: Richard Ji
> INET: richard_at_letsplay.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
-- Author: Rivaldi Bahar INET: rivaldi_bahar_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). -- Author: LoughMiller, Gregory INET: Gregory_LoughMiller_at_bscc.bls.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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-LReceived on Mon Aug 21 2000 - 09:16:28 CDT
 |
 |