Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle's Myth: keep tables and indexes in separate tablespaces
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