Re: single session I/O bandwidth

From: Kevin Closson <ora_kclosson_at_yahoo.com>
Date: Thu, 14 Mar 2013 10:22:36 -0700 (PDT)
Message-ID: <1363281756.6253.YahooMailNeo_at_web162802.mail.bf1.yahoo.com>

How busy and what is the I/O plumbing?�

Can't discuss SQL processing without mentioning CPU utilization and can't discuss PIO without discussing plumbing.

---

 From: Ls Cheng <exriscer_at_gmail.com>
To: Tanel Poder <tanel_at_tanelpoder.com> Cc: Oracle Mailinglist <oracle-l_at_freelists.org> Sent: Thursday, March 14, 2013 9:41 AM
Subject: Re: single session I/O bandwidth  

Hi
In IBM p7 I just run 32 parallels against a 50GB table using a count(*) and FTS and got 1350MB/sec in the XIV Array and all slaves were waiting for "direct path read", only 6 CPU (or thread since this AIX LPAR) were busy

Regards

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 14 2013 - 18:22:36 CET