Oracle Performance Tuning with AWR: What Time Interval Does the Load Value Represent?
We can clarify this through a simple experiment.
From this experiment, we can confirm that Oracle's LOAD value corresponds to the 1-minute load average (ldavg-1).
How Oracle Calculates Instance CPU Usage
Total CPU time used by the Oracle instance (17,562.40 seconds, from Time Model Statistics):
Total CPU time from OS Stats: BUSY_TIME + IDLE_TIME = 141,284.91 seconds.
%Total CPU = 17,562.40 / 141,284.91 = 12.4%
%Busy CPU = 17,562.40 / 19,057.13 = 92.2%
Understanding How Oracle Calculates Host CPU Usage
%Idle: 12,222,778 / (1,905,713 + 12,222,778) * 100 = 86.5%
%User: 1,560,943 / (1,905,713 + 12,222,778) * 100 = 11.0%
%System: 224,397 / (1,905,713 + 12,222,778) * 100 = 1.6%
%WIO (I/O Wait): 569,321 / (1,905,713 + 12,222,778) * 100 = 4.0%
Oracle performance tuning with AWR report (Part 3): Where Do Load Profile Metrics Come From?
Oracle performance tuning with AWR report (Part 2): Reverse Engineering Load Profile
#Oracle #OracleAWR, #DatabaseTuning, #OracleDBA #OracleACE #Database #DatabasePerformance #databasedba #dba
Oracle performance tuning with AWR report (Part 1):
Don't Read the Entire AWR Report—Only a Few Key Sections
