Re: single session I/O bandwidth
- From: Kevin Closson <ora_kclosson@xxxxxxxxx>
- To: "exriscer@xxxxxxxxx" <exriscer@xxxxxxxxx>, Tanel Poder <tanel@xxxxxxxxxxxxxx>
- Date: Thu, 14 Mar 2013 10:22:36 -0700 (PDT)
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@xxxxxxxxx>
To: Tanel Poder <tanel@xxxxxxxxxxxxxx>
Cc: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
