Yuan Oracle ACE

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).

24.04.2025 02:57 — 👍 0    🔁 0    💬 0    📌 0

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%

23.04.2025 03:42 — 👍 0    🔁 0    💬 0    📌 0

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%

23.04.2025 02:50 — 👍 0    🔁 0    💬 0    📌 0

Oracle performance tuning with AWR report (Part 3): Where Do Load Profile Metrics Come From?

23.04.2025 01:42 — 👍 1    🔁 0    💬 0    📌 0

Oracle performance tuning with AWR report (Part 2): Reverse Engineering Load Profile
#Oracle #OracleAWR, #DatabaseTuning, #OracleDBA #OracleACE #Database #DatabasePerformance #databasedba #dba

22.04.2025 08:20 — 👍 0    🔁 0    💬 0    📌 0

Oracle performance tuning with AWR report (Part 1):
Don't Read the Entire AWR Report—Only a Few Key Sections

18.04.2025 01:57 — 👍 0    🔁 0    💬 0    📌 0