Re: INDEX and DATA Tablespaces.....

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 17 Sep 2003 10:57:14 +1000
Message-Id: <3f67b208$0$28122$afc38c87@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 Received on Tue Sep 16 2003 - 19:57:14 CDT