Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!lnewsoutpeer00.lnd.ops.eu.uu.net!lnewsinpeer00.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Niall Litchfield" <niall.litchfield@dial.pipex.com>
Newsgroups: comp.databases.oracle.server
References: <bm2qs6$o1$1@bunyip.cc.uq.edu.au> <3f84f251$0$30614$afc38c87@news.optusnet.com.au> <7610580f.0310090351.1e152843@posting.google.com> <cf90fb89.0310100430.7c362905@posting.google.com>
Subject: Re: Oracle's Myth: keep tables and indexes in separate tablespaces
Date: Fri, 10 Oct 2003 20:32:02 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Lines: 29
Message-ID: <3f870919$0$6631$cc9e4d1f@news.dial.pipex.com>
NNTP-Posting-Host: 1Cust200.tnt28.lnd4.gbr.da.uu.net
X-Trace: 1065814298 news.dial.pipex.com 6631 62.188.156.200
X-Complaints-To: abuse@uk.uu.net
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245077

"Geomancer" <pharfromhome@hotmail.com> wrote in message
news:cf90fb89.0310100430.7c362905@posting.google.com...
> In my experience with Oracle on Windows, I demonstrated significant
> slowdown with the whole database on a single non-RAID disk.
>
> When I moved indexes to a separate disk, undo to another and redo to a
> 4th disk, performance doubled!
>
> Not sure why, maybe it's just a Windows thing.

Um, You seem to be saying that when you went from one to 4 disks/spindles
performance improved significantly. Well to misquote christine keeler "it
would wouldn't it" 4 disks for the IO is the significant factor not the
separation of tables and indexes. Nothing to do with windows and everything
to do with io split.


--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************