Oh I'm sure I have a copy at home, somewhere. I'm a packrat.
I was an almost brand-new DBA at the time, so I was on information
overload then, trying to learn Oracle and as as much as I could, all at
once (you try becoming the Oracle DBA without ever having seen Oracle
before!)
and yes, you do try (and as far as I can tell, succeed) not to say
things that won't stay true.
Blame my faulty memory on advancing old age :)
- Cary Millsap <cary.millsap_at_hotsos.com> wrote:
> If you can't find it, you can download it again from
> http://www.hotsos.com/catalog. I *promise* I haven't cheated and
> edited the
> document since the date that's published on its cover.
>
> Lots of people at the time (~1992) were preaching to separate indexes
> and
> data on different disks. The OFA gave you the *ability* to separate
> indexes
> from data on disk (if your I/O rates were high enough to motivate
> it), but I
> tried to avoid saying anything in that document that either wasn't
> true to
> begin with, or that was likely change as technology evolved.
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
>
> Upcoming events:
> - Hotsos Clinic 101 in Washington, Denver, Sydney
> - Hotsos Symposium 2004, March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
>
>
> -----Original Message-----
> Rachel Carmichael
> Sent: Tuesday, July 15, 2003 12:54 PM
> To: Multiple recipients of list ORACLE-L
> datafiles
>
> if I can still find it. :) I know Kevin did say "different disks"
> because I remember coming home from that presentation and trying to
> explain to my data center people why I needed something like 17 disks
> for my database.
>
> my apologies.... over the years, people have made the assumption that
> different tablespaces=different disks
>
>
>
> --- Cary Millsap <cary.millsap_at_hotsos.com> wrote:
> > :) Look carefully at the OFA paper. It does *not* say to put
> indexes
> > and
> > data on different *disks*. It says to put them in different
> > *tablespaces*.
> >
> >
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> >
> > Upcoming events:
> > - Hotsos Clinic 101 in Washington, Denver, Sydney
> > - Hotsos Symposium 2004, March 7-10 Dallas
> > - Visit www.hotsos.com for schedule details...
> >
> >
> > -----Original Message-----
> > Rachel Carmichael
> > Sent: Tuesday, July 15, 2003 10:44 AM
> > To: Multiple recipients of list ORACLE-L
> > datafiles
> >
> > yes, it's in the DBA Handbook but.... I believe I did see a paper
> > (with, I think, Cary's name on it. Sorry Cary!) way back when that
> > discussed OFA and how to set up your disks and it said to put the
> > indexes in a separate tablespace on a different disk
> >
> > back before the days of wait event tuning that is
> >
> >
> > --- rgaffuri_at_cox.net wrote:
> > > does anyoen disagree? Didnt this get started with the 'DBA
> > Handbook'
> > > or was it a different text?
> > >
> > > >
> > > > From: "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
> > > > Date: 2003/07/15 Tue AM 11:10:05 EDT
> > > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > > Subject: RE: should you seperate indexes from tables in
> seperate
> > > datafiles
> > > >
> > > > R,
> > > >
> > > > Some of it depends on the disk storage. I have always followed
> > the
> > > > time-proven method of organizing disks and placing indexes away
> > > from the
> > > > tables they belong to.
> > > >
> > > > Our warehouse is using EMC external disk. What the warehouse
> > > architect did
> > > > was to stripe the EMC disks in such a way that all mount points
> > > (Sun system)
> > > > are spread across all the EMC disks. What this does is to
> spread
> > > all files
> > > > in the database across all the EMC drives. And with 4 Gig of
> EMC
> > > cache
> > > > available, it further disproves the theory that separing
> indexes
> > > from data
> > > > are required. The end result, in my case, is almost like one
> big
> > > RAM disk -
> > > > where all disk IO is spread across all disk.
> > > >
> > > > If you do not have this arrangement, then I would still try and
> > > keep indexes
> > > > and data away from each other. But let's face it, we *never*
> > have
> > > enough
> > > > disk mount points, so we end up merging things together
> somewhat
> > > anyway.
> > > >
> > > > hope this helps.
> > > >
> > > > Tom Mercadante
> > > > Oracle Certified Professional
> > > >
> > > >
> > > > -----Original Message-----
> > > > Sent: Tuesday, July 15, 2003 10:49 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > > There has been alot of literature stating that you will recieve
> > > performance
> > > > improvements by seperating indexes and tables across multiple
> I/O
> > > points.
> > > >
> > > > Ie... you have a tables tablespace and an index tablespace. If
> > you
> > > put them
> > > > on seperate hard drives, you will have less I/O contention.
> > > >
> > > > Now Im seeing some articles stating that this is not true. That
> > > oracle
> > > > actually accesses indexes and tables serially. Now it might be
> > > useful
> > > > seperate indexes from tables for maintenance purposes but this
> > wont
> > > lower
> > > > I/O contention.
> > > >
> > > > Can anyone chime in on this? Curious to see where the evidence
> is
> > > leading?
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: <rgaffuri_at_cox.net
> > > > INET: rgaffuri_at_cox.net
> > > >
> > > > 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: Mercadante, Thomas F
> > > > INET: NDATFM_at_labor.state.ny.us
> > > >
> > > > 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
Received on Tue Jul 15 2003 - 12:45:40 CDT
