Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: INDEX and DATA Tablespaces.....
The "course" is wrong. The paper is right.
-- Cheers Nuno Souto wizofoz2k_at_yahoo.com.au.nospam "Alex Ivascu" <alexdivascu_at_sbcglobalNoSpamming.ComM> wrote in message news:3F6799EF.2000206_at_sbcglobalNoSpamming.ComM...Received on Wed Sep 17 2003 - 05:49:10 CDT
>
> 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
>