Re: To use SAME or NOT for High End Storage Setup ?

Not to hijack this thread but I have a related question...

What happens to random I/O service time when add drives to a stripe and/or increase/decrease the stripe size?
Is it the same, different, and why?


The reson I ask is that I have a warehouse design that is making heavy use of Oracle's spatial data (R-Tree) indexing and it seems to bottom out on db_file_sequential_read events. It appears that the spatial index processing does a lot of random reads, by rowid, to retrieve a blob, which evidently contains more rowids... Anyway I'd like to know if there are any optinions on how to improve this sort of performance, short of upgrading to 15KRPM drives.

thanks,
--Peter
--
http://www.freelists.org/webpage/oracle-l


Other related posts: