Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> data/index on different disks
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