Re: single session I/O bandwidth
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Tue, 12 Mar 2013 20:59:57 +1100
Message-ID: <513EFC9D.2060906_at_iinet.net.au>
and if you use dd, don't forget to set bs, ibs or obs to 8K or whatever the db block size is..
Otherwise you'll be measuring times for 512 byte I/O.
Date: Tue, 12 Mar 2013 20:59:57 +1100
Message-ID: <513EFC9D.2060906_at_iinet.net.au>
and if you use dd, don't forget to set bs, ibs or obs to 8K or whatever the db block size is..
Otherwise you'll be measuring times for 512 byte I/O.
-- Cheers Nuno Souto dbvision_at_iinet.net.au On 12/03/2013 6:05 PM, Iggy Fernandez wrote:Received on Tue Mar 12 2013 - 10:59:57 CET
> 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,
>
-- http://www.freelists.org/webpage/oracle-l