Go Back   Rhinocerus > Newsgroup > Newsgroup comp.databases.oracle.server

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 08-16-2012, 05:11 AM
vsevolod.afanassiev@gmail.com
Guest
 
Posts: n/a
Default interpretation of sar output for AIX LPAR

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?







Reply With Quote
Alt Today
Advertising
 
and become member of Rhinocerus
Standard Sponsored Links

Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




All times are GMT. The time now is 07:02 AM.


Copyright ©2009

LinkBacks Enabled by vBSEO 3.3.0 RC2 © 2009, Crawlability, Inc.