-
Continue reading →: Oracle Performance Tuning with AWR: What Time Interval Does the Load Value Represent?
In the “Host CPU” section of an AWR report, the Load Average Begin and Load Average End metrics represent the system workload at the beginning and end of the AWR snapshot interval, respectively. These values are obtained from the LOAD column in the DBA_HIST_OSSTAT table. If you are unfamiliar with…
-
Continue reading →: Understanding How Oracle Calculates Instance CPU Usage
In our previous article, we discussed How Oracle Calculates Host CPU Usage. Now we’ll explore Oracle instance CPU Usage. Instance-level CPU usage shows how much Oracle itself is consuming from the host’s CPU resources. Using the total CPU time used by the Oracle instance (17,562.40 seconds, from Time Model Statistics):…
-
Continue reading →: Oracle Performance Tuning with AWR: Understanding How Oracle Calculates Host CPU Usage
Monitoring host CPU usage is crucial for Oracle database performance. Here’s how Oracle calculates it using Operating System Statistics over a 29.62-minute snapshot with 80 CPUs. Total CPU Time: Host CPU Metrics: Using the total CPU time (14,128,491 hundredths of a second): Note: IOWAIT_TIME is part of IDLE_TIME, so don’t…
-
Continue reading →: How to Assess CPU Stress (Part 4/4): CPU Load
The Central Processing Unit (CPU) is the brain of a computer, and for IT professionals, assessing CPU stress is foundational knowledge. However, this task may not be as simple as you think. This is a 4-part article series aim to guide you in evaluating CPU stress. Part 1: Single-Core CPU…
-
Continue reading →: How to Assess CPU Stress (Part 3/4): CPU Run Queue Size
The Central Processing Unit (CPU) is the brain of a computer, and for IT professionals, assessing CPU stress is foundational knowledge. However, this task may not be as simple as you think. This is a 4-part article series aim to guide you in evaluating CPU stress. Part 1: Single-Core CPU…
-
Continue reading →: How to Assess CPU Stress (Part 2/4): Multi-Core CPU Utilization
The Central Processing Unit (CPU) is the brain of a computer, and for IT professionals, assessing CPU stress is foundational knowledge. However, this task may not be as simple as you think. This is a 4-part article series aim to guide you in evaluating CPU stress. Part 1: Single-Core CPU…
-
Continue reading →: How to Assess CPU Stress (Part 1/4): Single-Core CPU Utilization
The Central Processing Unit (CPU) is the brain of a computer, and for IT professionals, assessing CPU stress is foundational knowledge. However, this task may not be as simple as you think. This is a 4-part article series aim to guide you in evaluating CPU stress. Part 1: Single-Core CPU…
-
Continue reading →: Attending Database Synergy Day 2025 in Switzerland
Last week, I had the privilege of being invited to participate in the “Database Synergy Day 2025: Swiss Oracle & PostgreSQL User Groups Unite” conference held in Switzerland. This technical event was co-organized by the Swiss Oracle User Group (SOUG) and the PostgreSQL User Group (SwissPUG). I engaged in deep…
-
Continue reading →: Oracle AWR Report: Time Model Statistics
As always, I’ve developed a SQL script that yields the same results as this section. The source code is available below. To dive deeper into Oracle AWR analysis, download the full PowerPoint tutorial. Contact me on X, I’d love to share it with you for free! https://twitter.com/yuanoracle
-
Continue reading →: Oracle AWR Report: Wait Classes by Total Wait Time
As always, I I’ve developed a SQL script that generates the same results as this section, you can get the source code of this script here. To dive deeper into Oracle AWR analysis, download the full PowerPoint tutorial. Contact me on X, I’d love to share it with you for…
Hello,
I’m Yuan
Welcome to the blog of a performance maven in Oracle & MySQL. Feel free to contact me to share and discuss database knowledge.
My 20 Oracle Certifications
A screenshot from certview.oracle.com
My Book
MySQL 8.0 Operations and Optimization
Let’s connect
Stay updated with my latest blogs.
Yuan Yao, An Oracle ACE's Blog 