Re: single session I/O bandwidth

Was the XIV array throughput also via an Oracle session doing a FTS? And was it connected to the same server?

thanks.

On Tue, Mar 12, 2013 at 4:31 AM, Ls Cheng <exriscer_at_gmail.com> wrote:

> Hi
> I have this doubt for quite long time and asked qite a few people but seems
> that so far no one knows the reasoning.
>
> If I run a simple FTS query against a 8GB table for example I can observe a
> I/O throughput of around 30 to 40MB, if I run 2 session each get 30 to
> 40MB bandwidth too (aggregate 80MB/sec) however the storage array has more
> than that, the maximum throughput I got from an XIV array recently is 250MB
> read and 250MB write running 8 parallels.
>
> What is the mechanism which limits a single session cannot have more than
> 30, 40MB throughput? Some sort of SAN QOS?
>
> TIA
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l