Re: Locating a bad disk on Solaris w/Veritas

rhugga_at_yahoo.com (Keg) wrote in message ...
(large chunk snipped)
...
> Also, have you looked at mpstat and iostat while that query is
> running? That query is quite large and might be thrashing away at the
> disk. (are index/data seperated on diff devices, etc.. and all that
> stuff)

...
(more snipped)
...
> -rhugga

There is absolutely no proof to the myth that data and indexes must be on separate spindles; index/table access is serial, not parallel, so having your indexes separate from your table data is only for ease of management, i.e., if you hae a corrupt index tabblespace you can replace the indexes wihout losing your data. The old saw of 'separate your tables and your indexes on different disks' harkens back to Oracle 6, when hardware was not as efficient as it is today and it may have made some difference.

There is no compelling performance reason to separate tables and indexes in Oracle. This has been discussed many times in this newsgroup; one would hope the message is finally getting through.

David Fitzjarrell Received on Wed Oct 27 2004 - 07:51:56 CDT