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 on Linux - IO bottleneck

Re: ORACLE on Linux - IO bottleneck

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 13 Feb 2006 22:43:43 GMT
Message-Id: <pan.2006.02.13.22.43.42.953625@sbcglobal.net>


On Mon, 13 Feb 2006 09:05:00 +0100, Fabrizio Magni wrote:

> Hi Frank,
> don't blame me if I throw this link as well.
> It is incomplete... but still I hope for a feedback.

Definitely a good article. I was surprised about the large drop in the max response time when going from 4K --> 8K:

TPS: 24,82
kBPS: 50.409
Total executions: 5584
Total Rows: 67179
Total kBytes: 11338,879
Average response time: 0.034
Maximum response time: 0.464

TEST8K: TPS: 24,72
kBPS: 50.090
Total executions: 5564
Total Rows: 66809
Total kBytes: 11272,059
Average response time: 0.036
Maximum response time: 0.246

Throughput was larger with the 4K block. Strange.

-- 
http://www.mgogala.com
Received on Mon Feb 13 2006 - 16:43:43 CST

Original text of this message

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