Re: INDEX and DATA Tablespaces.....

From: Goran <goran99_makni_at_yahoo.com>
Date: Wed, 17 Sep 2003 16:01:47 +0200
Message-ID: <bk9pgb$oh0$1@fegnews.vip.hr>

"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.... Received on Wed Sep 17 2003 - 09:01:47 CDT