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

Home -> Community -> Usenet -> c.d.o.server -> Re: INDEX and DATA Tablespaces.....

Re: INDEX and DATA Tablespaces.....

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 17 Sep 2003 08:26:38 -0700
Message-ID: <1063812387.594043@yasure>


Goran wrote:

>"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
>news:3f67b208$0$28122$afc38c87_at_news.optusnet.com.au...
>
>
>>Alex Ivascu wrote:
>>
>>
>>
>>>Hari Om wrote:
>>>
>>>
>>>>I am using Oracle 9.2.0.1 on IBM AIX 5.1L system.
>>>>
>>>>When designing DB and its physical layout.....do I need to SEPERATE
>>>>INDEX TABLESPACE from its DATA TABLESPACE.....Oracle DBA Book by Loney
>>>>says to better seperate these 2 Tablespaces....but some of the folks
>>>>here in the google say it should be on SAME DISK.....kindly
>>>>confirm......Any related links are appreciated.
>>>>
>>>>THANKS!
>>>>
>>>>
>>>Separate them. That's the first thing that any I/O Performance tuning
>>>course teaches you. This should help you, too:
>>>
>>>
>>>
>http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm#sthref787
>
>
>>And one of the first things any *good* I/O Performance tuning course
>>
>>
>should
>
>
>>teach you is that that particular piece of advice is total nonsense.
>>
>>HJR
>>
>>
>
>
>With all due respect, how can two (whatever) datafiles on the same disk give
>*the same* (or even better) performance as the same two on separate disks?
>
>Regards....
>
>
>

Who puts them on the same disk. Datafiles should be spread over multiple disks by striping. And that said ... there is no perofrmance based reason to separate tables and indexes into separate tablespaces for performance.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Sep 17 2003 - 10:26:38 CDT

Original text of this message

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