Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!fr.ip.ndsoftware.net!proxad.net!proxad.net!194.159.246.34.MISMATCH!peer-uk.news.demon.net!kibo.news.demon.net!demon!newshub1.home.nl!home.nl!not-for-mail From: Frank van Bortel Newsgroups: comp.databases.oracle.server Subject: Re: data/index on different disks Date: Thu, 03 Mar 2005 17:02:21 +0100 Organization: @Home Benelux Lines: 30 Message-ID: References: <1109864108.605757.196650@f14g2000cwb.googlegroups.com> Reply-To: fvanbortel@netscape.net NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news2.zwoll1.ov.home.nl 1109865598 26348 212.204.168.125 (3 Mar 2005 15:59:58 GMT) X-Complaints-To: usenet@corp.home.nl NNTP-Posting-Date: Thu, 3 Mar 2005 15:59:58 +0000 (UTC) User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en In-Reply-To: <1109864108.605757.196650@f14g2000cwb.googlegroups.com> Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237372 sigdock wrote: > 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 > Splitting Index and Data was a myth. Indexes and data do not get read or written simultaneously, it's a serialized action: first read the index, then the data. As text indexes are *not* updated (you need another process) when the data is updated, this question is even more obvious to answer: Don't bother, unless for maintenance reasons. There has been an extensive thread recently on this subject - google! -- Regards, Frank van Bortel