Without trying to offend anyone, I personally believe
that any recommendation about "data", "indexes",
"temp" being separate is missing the original point
about what is actually being sought after - namely,
even distribution of IO across all of the disks. All
of the current theories (SAME, data separate from
indexes, etc etc) are all about achieving that.
For example, you could probably get away with a big
chuck on rarely accessed data on the same disks as
redo logs, similarly, a single table might need to be
striped across 10 disks because it gets pounded by
everything...
I would forget about "data" and "indexes" and look
more at whats "hot" and "cold" (from an IO
perspective) and try to work from there...
hth
connor
- "C.S.Venkata Subramanian" <csvenkata_at_lycos.com>
wrote: > Hi,
> I will recommend a combination of RAID 1 and RAID 0
> over RAID 5 or other RAID's. Offcourse reading is
> slower but writing is faster. From your given
> information, I can see that I/O is evenly
> distributed. Never put archived logs and REDO logs
> in one disk. same ways index and data should not be
> clubbed together. I have seen RAID 1 and 0 gives
> better performance than RAID 5 and also improved
> performance if we distribute I/O with different RAID
> controllers.
>
> HTH
> --
>
> On Tue, 24 Apr 2001 23:45:20
> Saumya99 wrote:
> >Hi Chris,
> >The concern is the putting datafile on RAID system.
> Oracle documentation
> >recommends not to put datafiles on RAID because
> reading from a RAID device
> >is slower whereas writing is a faster process.
> Particularly when you are
> >thinking of Performance benefit, you can give a
> consideration here.
> >
> >-Saumyajit
> >
> >
> >
> >
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> >Sent: Wednesday, April 25, 2001 1:22 AM
> >
> >
> >> Hello all,
> >>
> >> We are moving our production database onto new
> disks to improve
> >> performance. It is a high transction OLTP
> environment using Oracle8i on
> >> a SPARC Solaris box. We are divided about which
> parts of Oracle to put
> >> where for the best performance. We have come up
> with two basic
> >> designs.
> >>
> >> A-C are SCSI controllers, 0-18 are 36GB hard
> disks. B & C each are
> >> connected to hardware RAID controllers. A has
> two disks mirrored
> >> through software.
> >>
> >> SETUP I:
> >>
> >> A0: Solaris & Oracle Software
> >> A1: A0 soft mirror
> >> B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs
> >> C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO
> logs, TOOLS, ROLLBACK
> >> (extra disks used in other systems)
> >>
> >> SETUP II:
> >>
> >> A0: Solaris & Oracle Software
> >> A1: A0 soft mirror
> >> B[RAID 0+1]2-7: DATA
> >> B[RAID 1]8-9: REDO logs, SYSTEM
> >> C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO
> Logs, TOOLS
> >> C[RAID 1]16-17: ROLLBACK
> >>
> >> Or is there an even better way to arrange the
> data?
> >>
> >> Thanks,
> >>
> >> Chris
> >> --
> >> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >> --
> >> Author: Chris Rezek
> >> INET: crezek_at_dotclick.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).
> >
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >--
> >Author: Saumya99
> > INET: saumya99_at_yahoo.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).
> >
>
>
> Get 250 color business cards for FREE!
> http://businesscards.lycos.com/vp/fastpath/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: C.S.Venkata Subramanian
> INET: csvenkata_at_lycos.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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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).
Received on Wed Apr 25 2001 - 15:17:29 CDT