Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: To use SAME or NOT for High End Storage Setup ?

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

From: Peter Sylvester <peters_at_mitre.org>
Date: Thu, 11 May 2006 14:55:02 -0400
Message-ID: <44638886.7030203@mitre.org>


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 Received on Thu May 11 2006 - 13:55:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US