Re: INDEX and DATA Tablespaces.....

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
>
>
> Alex Ivascu
>

Absolutely not: The courses are wrong. The only credible reason for separating them is with respect to ease of maintenance but certainly not for peformance. The performance thing has been proven over and over again to be untrue no matter how many books it has been written in. I'd strongly suggest reviewing postings over the last several years in these usenet groups by Tom Kyte, Jonathan Lewis, Richard Foote, Howard Rogers, etc. It is just mythology that needs to have a knife stuck in it and should not be repeated.

If you truly want to spread I/O ... stripe and mirror everything (SAME).

-- 
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)