Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE on Linux - IO bottleneck
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.comReceived on Mon Feb 13 2006 - 16:43:43 CST