Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.litech.org!news.glorb.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: "sigdock" <sigdock@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: data/index on different disks
Date: 3 Mar 2005 07:35:08 -0800
Organization: http://groups.google.com
Lines: 14
Message-ID: <1109864108.605757.196650@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 213.154.233.200
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1109864112 14987 127.0.0.1 (3 Mar 2005 15:35:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Mar 2005 15:35:12 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=213.154.233.200;
   posting-account=3ioDbgwAAADsKOyvQIy7q3hfnk1orEhR
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237369

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