interpretation of sar output for AIX LPAR

From: <vsevolod.afanassiev_at_gmail.com>
Date: Wed, 15 Aug 2012 22:11:19 -0700 (PDT)
Message-ID: <e8570eac-453a-4ae1-a6c5-3e2a3e653dc4_at_googlegroups.com>

I am trying to understand the meaning of sar output for AIX LPAR. Example: this LPAR has entitlement = 7 CPU

14:58:10    %usr    %sys    %wio   %idle   physc   %entc
14:58:11      24       8       8      60    2.33    33.3
14:58:12      22      10       7      61    2.29    32.7
14:58:13      24      10      10      57    2.44    34.8
14:58:14      27      10       9      54    2.67    38.1
14:58:15      23       9       9      58    2.35    33.6

My interpretation: at 14:58:12 this LPAR was allocated 2.29 physical CPU. Out of these 2.29 CPU it ised 22% in user mode and another 10% in kernel mode. So in physical CPU terms utilization was 2.29 x 32% = 0.73 CPU. Assuming all this utilization could be attributed to Oracle and remained constant for 1 hour I should see in Statspack for 1 hour interval

Statistic                                       Time (s) % of DB time
----------------------------------- -------------------- ------------
DB CPU                                             2,628

as 3,600 x 0.73 = 2,628.

Is it correct interpretation? Received on Thu Aug 16 2012 - 00:11:19 CDT