Solved

Percentage of CPU Usage report AIX Vs. OEM

Posted on 2013-05-23
5
1,952 Views
1 Endorsement
Last Modified: 2013-05-24
Experts -

I do have a discrepancy  on %CPU usage reports between AIX and OEM. For last 31 days, OEM is reporting %CPU around 40% and below, where AIX reporting around 80% consistently for last 2 months and came down couple of days ago.  How can I prove that AIX report is wrong?

or, how can I see the AIX history of CPU Usage for last 2 weeks?

The AIX report was generated from NMON utility.

Thanks,
Sve.
1
Comment
Question by:sventhan
  • 2
  • 2
5 Comments
 
LVL 5

Assisted Solution

by:Eikroman
Eikroman earned 333 total points
ID: 39193684
Hello,

Although I have no real thought about the problem in question, it may help if you provide full samples of the reports.

Usually, such discrepancies are often associated with different measured metrics for example overall CPU (NMON) usage and CPU consumed by a component like Oracle DB processes (by OEM).  

Another possibility, is when reports are for different time period. "Real-Time" monitoring will catch every peak utilization, while daily report or monthly will display average statistics and so on.

But since I have no knowledge of what report is actually being used, I can only speculate. Give us some screenshots or something.
0
 
LVL 18

Author Comment

by:sventhan
ID: 39193806
Please find the screen shots attached.

Thanks for looking.
cpu-cmpre.docx
0
 
LVL 15

Assisted Solution

by:Franck Pachot
Franck Pachot earned 167 total points
ID: 39193864
Hi,

The NMON report is not very clear. Is it a %CPU ? It scales from 0 to eleven !

But it seems that the report measures the 'Physical CPU'

OEM is measuring what the OS sees, and that's logical CPU.

It guess that the difference comes from that. 80% of 16 physical CPU is the same load as 40% of 32 Logical CPU. You should have the numbers in v$osstat to confirm.

Regards,
Franck.
0
 
LVL 5

Accepted Solution

by:
Eikroman earned 333 total points
ID: 39193867
Ok.
The OEM screenshot is showing data for the "Last 31 Days"
The NMON shows data between May 13 - to May 20 (7 days).  
So right here we have big difference in the reports granularity. OEM will not displays peaks in this mode. To have a more meaningful comparison:
1) Click on "CPU utilization" under the first graphic
2) On the right at the "View Data" select "Custom"
3) Select a range that is similar to the NMON report. You may experiment by selecting exact ranges as in the NMON or even smaller, like from May 16 to May 20, this way OEM report will be much more verbose.

Also,
It's not clear what exactly is being measured in NMON graphics. Is it 10%? Then why 11? Is it for all cores or single core?

Keep in mind that OEM graphic displays CPU usage in percents for ALL CORES. Meaning that if you have 4 cores, and one core is at 100%, the OEM will show 25% and if 2 cores are being used, the graphic will show 50%. I'm not familiar with NMON, and do not know, how you generate this graphic, but in Linux, for example, the TOP command displays percentage for the CPU Core. If compared to OEM, it will produce 100% and 200%  against 25% and 50% in OEM.

Let's continue with OEM report that I described earlier and see if there is a similar pattern for smaller ranges.

I personally doubt that there is a bug in either NMON or OEM, it looks more like different metrics, granularity or visualization method
0
 
LVL 18

Author Comment

by:sventhan
ID: 39193958
I've requested that this question be deleted for the following reason:

Need to edit the question
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  â€¦
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now