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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > > > > > > --- [EMAIL PROTECTED] wrote: > > > does anyoen disagree? Didnt this get started with the 'DBA > > Handbook' > > > or was it a different text? > > > > > > > > > > > From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> > > > > Date: 2003/07/15 Tue AM 11:10:05 EDT > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > > 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: <[EMAIL PROTECTED] > > > > INET: [EMAIL PROTECTED] > > > > > > > > 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: [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.net > > > > -- > > > > Author: Mercadante, Thomas F > > > > INET: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and > > in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > === message truncated === __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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).
