Re: User datafiles and index on separate disks

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 30 Sep 2003 17:53:05 +1000
Message-ID: <3f793720$0$1691$afc38c87@news.optusnet.com.au>

Peter wrote:

> Is it a must to place datafiles, undo segments and table index on
> separate disks? If not, what are the benefits of doing so?
>
> Thanks

Please go to www.google.com and search the archives there for a thread in this very newsgroup called 'Oracle Myths'. A number of hits will appear, but you want the one with about 149 posts in the thread.

It *was* a very long-running argument.

Short story: indexes and tables do not need to be separated for performance reasons, but probably do for management convenience. Undo segments should most definitely be kept separate from everything else. Unless you have some sort of RAID, in which case, the whole concept of separate disks is a bit meaningless.

Regards
HJR Received on Tue Sep 30 2003 - 02:53:05 CDT