Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: "Never split index and data files ..."

RE: "Never split index and data files ..."

From: Allan Robertson <robertson_allan_at_hotmail.com>
Date: Fri, 20 Apr 2001 04:26:20 -0700
Message-ID: <F001.002ED92F.20010420032021@fatcity.com>

There is also an article on Wide Thin Disk Striping at Sun Blue prints

http://www.sun.com/software/solutions/blueprints/1000/layout.pdf

which expands on this philosophy.

Allan

>From: "Steve Adams" <steve.adams_at_ixora.com.au>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: "Never split index and data files ..."
>Date: Thu, 19 Apr 2001 23:25:25 -0800
>
>Hi All,
>
>The author (Anjo Kolk) is an advocate of SAME (stripe and mirror
>everything).
>The SAME philosophy is that "everything" should be striped across all the
>disks
>available. Separating indexes from their tables is contrary to that
>philosophy.
>I don't agree with it, but that's where he's coming from anyway.
>
>@ Regards,
>@ Steve Adams
>@ http://www.ixora.com.au/
>@ http://www.christianity.net.au/
>
>
>-----Original Message-----
>Sent: Friday, 20 April 2001 6:56
>To: Multiple recipients of list ORACLE-L
>
>
>Whoaaa, I sure hope someone can, because I have never heard that before?
>Kev
>
>-----Original Message-----
>Ghosalkar
>Sent: Thursday, April 19, 2001 4:36 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Guys,
>
>i was checking my statspack report on oraperf and i came across this
>statement.
>
>"Never split index and data files to different sets of disks."
>
>can anyone xplain the logic behind this.
>
>Thanks
>Mandar
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
>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 Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Allan Robertson
  INET: robertson_allan_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).
Received on Fri Apr 20 2001 - 06:26:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US