Re: User datafiles and index on separate disks

Peter schrieb:
> 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
>
>

No, you can have all files on one disk.
The benefit is performance - when e.g. indices and data files are on the same disk, and oracle will use an index to locate a row, the disk header should go to the index file first, read some blocks, than go to the datafile and read the data block. The movement of the header is very expensive in terms of time!

Regards!
Rainer

-- 
------------------------------------------------
Rainer Herbst         Linux - Registered
ZEIK                  User #319157
Universität Potsdam   Usual disclaimers applied!
------------------------------------------------