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: RE: should you seperate indexes from tables in seperate datafiles

RE: RE: should you seperate indexes from tables in seperate datafiles

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Tue, 15 Jul 2003 11:21:52 -0500
Message-Id: <25929.337845@fatcity.com>


:) 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-----
From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On Behalf Of Rachel Carmichael
Sent: Tuesday, July 15, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L Subject: Re: RE: should you seperate indexes from tables in seperate 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


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: wisernet100_at_yahoo.com

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 - 11:21:52 CDT

Original text of this message

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