RE: single session I/O bandwidth
From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Tue, 12 Mar 2013 00:05:05 -0700
Message-ID: <BLU165-W27EFC63E8F504DB956FCAAEBE20_at_phx.gbl>
Why is the basis of the assumption that a single Oracle thread has more capacity that that? Trace one of the threads for a while using "strace -c" to produce a summary and you will see how time is spent within the thread. You can also check a summary trace of a "dd of=/dev/null" command. Chances are you will see higher throughput but dd much less processing than an Oracle thread. Kindest regards,
Iggy
> What is the mechanism which limits a single session cannot have more than> 30, 40MB throughput? Some sort of SAN QOS?
Date: Tue, 12 Mar 2013 00:05:05 -0700
Message-ID: <BLU165-W27EFC63E8F504DB956FCAAEBE20_at_phx.gbl>
Why is the basis of the assumption that a single Oracle thread has more capacity that that? Trace one of the threads for a while using "strace -c" to produce a summary and you will see how time is spent within the thread. You can also check a summary trace of a "dd of=/dev/null" command. Chances are you will see higher throughput but dd much less processing than an Oracle thread. Kindest regards,
Iggy
> What is the mechanism which limits a single session cannot have more than> 30, 40MB throughput? Some sort of SAN QOS?
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 12 2013 - 08:05:05 CET