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 -> data/index on different disks

data/index on different disks

From: sigdock <sigdock_at_hotmail.com>
Date: 3 Mar 2005 07:35:08 -0800
Message-ID: <1109864108.605757.196650@f14g2000cwb.googlegroups.com>


Hi all,

I'm building a database for Oracle Text, using Oracle 10.1 on a Win2k3 platform. Estimated initial size 3GB data and an expected growth of 500MB a year. Since I'm using a text index I wonder if it's wise to put the index and data tablespaces on different disks. I know that was common practice in the Oracle7 and Oracle8(i) days but I remember reading somewhere that in Oracle9 and up it's better to put index and data on the same disk. Better for read-performance anyway. Anybody here with the answer???

tia,
Bert Jan Meinders Received on Thu Mar 03 2005 - 09:35:08 CST

Original text of this message

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