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: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 10 Oct 2003 08:17:37 -0700
Message-ID: <1065799068.141452@yasure>


Geomancer wrote:

>>No, Eienstein. (I guess we know why you are unemployed).
>>
>>
>
>Um, had you made several caveats and been less insulting, your point
>might have been better taken.
>
>If the disk is not RAID striping (RAID10, 0+1, 5) then many of your
>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.
>
>

Probably also a very small number of simultaneous transactions thing.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Oct 10 2003 - 10:17:37 CDT

Original text of this message

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