AWR shows incorrect cpu time in IBM AIX (Doc ID 1631769.1)

Last updated on AUGUST 04, 2018

Applies to:

Symptoms

• After upgrading database to 11.2.0.4, AWR reports is showing very high DB-Time in IBM AIX 6.1 (this is also applicable to AIX 7.1)
  
  Statistic Name                   Time (s)                         % of DB Time
  DB CPU                            17,582,053,544.85               100.00 <<<
  sql execute elapsed time    3,099.53                             0.00
  parse time elapsed            1,239.93                             0.00
    
   
  
  
• But the "Operating System Statistics - Detail" section of the AWR do not show much cpu utilization
  Snap Time                               Load   %busy     %user      %sys       %idle        %iowait
  16-Dec 21:59:33                      0.77
  16-Dec 22:26:07                      1.04     3.58         2.14       1.43        96.42           6.26 <<< 

    

Changes

 Upgrade of database from 9.2.0.8 to 11.2.0.4 in IBM AIX 6.1. 

Cause