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: Noons <wizofoz2k_at_yahoo.com.au>
Date: Wed, 17 Sep 2003 20:49:10 +1000
Message-ID: <3f684182$0$14558$afc38c87@news.optusnet.com.au>


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

>
> 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
>
Received on Wed Sep 17 2003 - 05:49:10 CDT

Original text of this message

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