Steve,
I heard about this SAME philosophy at the last NorthEast Oracle Users Group
meeting from a individual who works on the utilities for Oracle in the New
England Development Office. Although we did not get deeply into the philosophy,
I'll agree that it is not the silver bullet, actually it can become a
performance detractor. The individual who wrote the paper for Oracle (Anjo
Kolk) is a LONG time Oracle person, actually wrote the core of the kernel, so I
believe he's probably writing from a purely theoretical point of view. In that
light what he's saying would be true, stripe & mirror everything and
theoretically you should never have an io bottleneck. BUT, many hardware
platforms don't handle mirroring very well unless your using a disk array like
EMC's. Now that handles the mirror internally so we've alleviated that problem,
but EMC likes to break their drives into 'hyper volumes' so your stripping may
or may not be across physical drives. Also your stripes can still have the
bottle neck of the number of SCSI cards in the computer. In any case taking a
little time to insure that redo logs, archive logs, indexes, and data are all
REALLY spread out across devices is the only way to go. SAME is a great theory,
but I can't and haven't seen it perform well in practice, yet.
Dick Goulet
____________________Reply Separator____________________
Author: "Steve Adams" <[EMAIL PROTECTED]>
Date: 4/19/2001 11:25 PM
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
