-
Continue reading →: CPU Hyper-Threading Explained: How Hyper-Threading Skews CPU Usage Readings (Part 2 of 3)
This is Part 2 of a 3-part article series to explore CPU Hyper-Threading.Part 1: What Is CPU Hyper-Threading?Part 2: How Hyper-Threading Skews CPU Usage ReadingsPart 3: Does Hyper-Threading Boost CPU Performance—and by How Much? How Hyper-Threading Skews CPU Usage Readings Because the operating system collects CPU usage metrics based on…
-
Continue reading →: CPU Hyper-Threading Explained: What It Is (Part 1 of 3)
Hyper-Threading is a well-established CPU technology that transforms a single physical CPU core into two separate logical processors by sharing certain execution resources, enhancing parallelism and efficiency. I am going to write a 3-part article series on this technology to explore its ins and outs, though these will only scratch…
-
Continue reading →: Unmasking CPU Starvation in Oracle (Part 1/3): Why Doesn’t % DB Time Add Up to 100%?
This article explores how CPU starvation manifests in Oracle AWR reports. The discussion is divided into three parts: Why Doesn’t % DB Time Add Up to 100%? In Oracle, DB Time is composed of two components: time spent using the CPU (DB CPU) and time spent not using the CPU…
-
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…
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 26 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 