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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Performance -- Possible Disk Bottleneck

Re: Oracle Performance -- Possible Disk Bottleneck

From: Greg Rahn <greg_at_structureddata.org>
Date: Sat, 09 Jun 2007 03:35:15 -0000
Message-ID: <1181360115.073861.50670@z28g2000prd.googlegroups.com>


If you perceive that you may have suboptimal storage layout and you can get exclusive access to the host, you may want to use the Oracle Orion tool @ http://www.oracle.com/technology/software/tech/orion/index.html. This will give you some good numbers of the IOPS and latency for various IO sizes.

At one point in this thread it is mentioned that a 15k drive can do 180 IOPS. That is probably a number from a drive spec sheet, meaning that is the highest possible under very precise circumstances. e.g. very small size and totally sequential. In reality, half of that number is probably reasonable. If you choose to use Orion, it will give you an IOPS number.

--
Regards,

Greg Rahn
http://structureddata.org
Received on Fri Jun 08 2007 - 22:35:15 CDT

Original text of this message

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