@YuanOracle profile picture
Yuan Oracle ACE @YuanOracle

Oracle ACE, 20 Oracle certifications. Sharing AWR, ASH and SQL tuning insights.

Joined March 2019
  • Tweets 275
  • Following 435
  • Followers 316
107 Photos and videos
1
5
40
Scraped Through the Oracle Exadata X9M Implementation Specialist Exam (1Z0-902) byte-way.com/2026/04/27/scra…

Scraped Through the Oracle Exadata X9M Implementation Specialist Exam (1Z0-902)

This week, I tackled the Oracle Exadata Database Machine X9M Implementation Essentials (1Z0-902) exam. With the passing score set at 64%, I emerged with a 65%. Some might call it a close shave; I c…

byte-way.com
3
793
Estimating I/O Efficiency with Little's Law Using Oracle AWR Report byte-way.com/2026/03/24/esti… #OracleACE #Oracle #OracleAWR

Estimating I/O Efficiency with Little’s Law Using Oracle AWR Report

In queueing theory, there is a fundamental theorem known as Little’s law, authored by John Little. As documented on Wikipedia, the law states that the long-term average number of customers (L…

byte-way.com
1
64
Oracle 26ai OCP #oracleACE #Oracle
1
5
90
Does Your Storage Respond Fast Enough? byte-way.com/2026/02/12/does… #Oracle #OracleACE #OracleAWR

Does Your Storage Respond Fast Enough?

The response time of the storage subsystem is critical to overall Oracle database performance. Assessing storage responsiveness can be challenging for DBAs who lack direct access to the Operating S…

byte-way.com
1
54
byte-way.com/2026/02/10/dete… CPU-noisy neighbors are non-Oracle processes that consume significant CPU resources and reduce the CPU available to the database. This blog explores how to detect the presence of them. #Oracle #OraceACE #OracleAWR

Detecting CPU-Noisy Neighbors in Oracle

In Oracle environments, CPU-noisy neighbors are non-Oracle processes that consume significant CPU resources and reduce the CPU available to the database. CPU-noisy neighbors can be detect by compar…

byte-way.com
2
53
Step-by-Step: Installing Oracle 26ai RAC Database on Linux Using VMware – Yuan Yao, An Oracle ACE's Blog byte-way.com/2026/02/04/step… #oracle #oracleACE #oracleRAC

Step-by-Step: Installing Oracle 26ai RAC Database on Linux Using VMware

Conceptual Architecture A conceptual architecture diagram of Oracle RAC is as follows: The biggest obstacles to building a private RAC test environments is the requirement for shared storage. Tradi…

byte-way.com
3
65
Step-by-Step: Installing Oracle 26ai via RPM and Creating Databases byte-way.com/2026/01/29/step…

Step-by-Step: Installing Oracle 26ai via RPM and Creating Databases

Installing Oracle Database on Linux using RPM packages significantly reduces deployment complexity. Many intricate configuration steps are handled automatically during the package installation. Thi…

byte-way.com
2
38
Oracle AI Database 26ai is not officially supported on Linux 7😢
2
34
Public commits to the MySQL Server GitHub repository appear to have been inactive for more than four months, the lowest in years. At the same time, Oracle has layoffs ~70 core MySQL engineer. Rumor has it that Oracle is abandoning MySQL, Can you clarify it? #MySQL #OpenSource #Oracle @sunbains @MySQL @Oracle @OracleDatabase @mandypang @nipunag @fredtang @srikrishnang @lefred @oracleace
1
365
Why Incremental Backups Can Be Deadlier Than Full Backups byte-way.com/2026/01/15/why-…

Why Incremental Backups Can Be Deadlier Than Full Backups

A common assumption in Oracle database administration is that incremental backups are inherently lighter than full backups. However, a recent real-wold case revealed a counterintuitive result.

byte-way.com
1
62
While stating that most IT professionals read CPU metrics wrong is a bold claim, it is not an exaggeration. youtube.com/watch?v=jmcHcAeD… #Oracle #OracleACE #CPU

1
2
98
How can a system be 90% idle yet still be starving for CPU? youtu.be/ZIJZ6u15Ag0?si=UuNb… via @YouTube #OracleACE #Oracle #MySQL
1
4
192
When host CPU is saturated but Oracle Instance CPU is only 12.3%, it usually means Oracle is not the real CPU consumer. After checking, we found multiple Oracle instances running on this same AIX host.
1
1
6
389
AI seems poised to replace every human job, but it's merely "micro-intelligent"—narrow and task-specific. In the IT world, architects will be the last holdouts. Globally? Philosophers will outlast us all. Do you agree? #AI #FutureOfWork
3
88
Oracle AWR Case Study: An Atypcal “buffer busy wait" youtu.be/vTWCvOiY8ds?si=oCU1… via @YouTube #Oracle #OracleACE #AWR

Oracle AWR Case Study: An Atypcal “buffer busy wait"

Oracle AWR report tutorial series videos

youtube.com
2
6
239
Load more