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 -> Re: Oracle's Myth: keep tables and indexes in separate tablespaces

Re: Oracle's Myth: keep tables and indexes in separate tablespaces

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Sat, 11 Oct 2003 23:20:18 +1000
Message-ID: <3f880544$1$28120$afc38c87@news.optusnet.com.au>


"Geomancer" <pharfromhome_at_hotmail.com> wrote in message news:cf90fb89.0310100430.7c362905_at_posting.google.com...
> points may be correct.
>
> 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.

Well, you go from a single spindle to 4 and you not sure why? :) and I'll bet with you that if you move your indexes back to the tables disk and leave everything else the same on the remaining two disks, you won't even notice any degradation!

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Sat Oct 11 2003 - 08:20:18 CDT

Original text of this message

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