-
Continue reading →: The “Poor Man’s” Oracle 26ai RAC on Proxmox
In production, building an Oracle RAC meant investing in an expensive Fibre Channel or iSCSI SAN (Storage Area Network) with dedicated physical hardware—costing thousands of dollars. For years, the “poor man’s” RAC was to use VMware with the multi-writer flag, Since VMware vSphere/ESXi is no longer truly free (the free…
-
Continue reading →: 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 console myself by calling it a perfectly calibrated effort for one of the most demanding certifications…
-
Continue reading →: 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) in a stationary system is equal to the long-term average effective arrival rate (λ) multiplied by the average time…
-
Continue reading →: 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 System and cannot utilize traditional tools like iostat or sar. Oracle provides a critical metric for this purpose: Average Synchronous Single-Block…
-
Continue reading →: 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 comparing total OS CPU usage with Oracle CPU usage. If the gap between is huge, it strongly suggests the presence of a CPU-noisy…
-
Continue reading →: 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. Traditionally, this necessitates expensive SAN hardware.However, by leveraging VMware ESXi’s advanced disk attributes, specifically the multi-writer flag, we can simulate a professional…
-
Continue reading →: 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. This article demonstrates the process of installing Oracle 26ai using the RPM method on RHEL 9. 1. Linux Operating System Preparation To resolve dependency issues on RHEL,…
-
Continue reading →: 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.
-
Continue reading →: Troubleshooting ORA-01152: When Datafiles are “From the Future”
The ORA-01152 error is a common headache for DBAs, particularly after a database restore operation or when recovering from a backup control file. It essentially tells you that your database files are “newer” than your control file expects. Below is a guide on how to diagnose the issue and resolve…
-
Continue reading →: Evaluating Storage Performance by AWR Snapshot Raw Data
As a DBA, having a clear understanding of your storage performance is essential to correctly judge overall database behavior. However, in many enterprises, DBAs do not have OS-level access, so they cannot use tools like iostat or sar. Fortunately, Oracle’s AWR Snapshot Raw Data retains historical I/O performance metrics that…
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 