-
Continue reading →: Diagnosing Parsing Issue with ASH
Parsing, especially hard parsing, are non-productive operation and can consume significant system resources, leading to library cache contention. ASH can be used to diagnose and analyze excessive parsing through its sampling mechanism. This blog explores how to effectively use ASH to identify parsing issues. Simulating a Parsing Issue First, we…
-
Continue reading →: Sample-Based SQL Runtime Calculation: Deduce SQL execution time with ASH
In the realm of database performance monitoring, identifying and resolving sporadic performance issues caused by outlier SQL statements can be particularly challenging. Traditional tools often rely on periodic snapshot and averages, which average out spikes and outliers, this limitation therefore obscures the identification of transient performance anomalies. This blog is…
-
Continue reading →: Script: Monitoring Running SQL in Oracle Database in Real Time
The output below is an example you can expect:
-
Continue reading →: The Difference between V$SQL, V$SQLAREA, and V$SQLSTATS
Oracle Database provides three dynamic views for querying execution statistics of all SQL statements currently cached in the Library Cache of the Shared Pool. They are V$SQL, V$SQLAREA and V$SQLSTATS. This article explores the differences between them. V$SQL has one row for each different version of a SQL statement. This…
-
Continue reading →: From Underestimation to Victory: My Journey to Oracle Performance Management and Tuning Certification (1z0-084)
In my daily work, I can be considered an Oracle and MySQL database optimization expert. Recently, I embarked on the journey to validate my expertise by pursuing Oracle Certified Professional Oracle Database 19c: Performance Management and Tuning Certification (exam code is 1z0-084). Although the process was not smooth, I eventually…
-
Continue reading →: Having Acquired Two Free Oracle Certifications: OCI and AI
I have obtained more than 20 Oracle certifications, of all these certifications, only two are free. Oracle Cloud Infrastructure 2023 Architect Associate This certification is designed for Cloud Solution Architects and Cloud Engineers who wish to gain a deep understanding of core OCI (Oracle Cloud Infrastructure) services to design and…
-
Continue reading →: A Seemingly Simple Question: Can a Single Select SQL Statement Be Counted as a Transaction?
The number of transactions is an important metric for measuring the load on an Oracle database, e.g., in TPC-C benchmarks. A transaction typically consists of SQL statements that modify data. However, a seemingly simple question arises: Can a single select SQL statement without data modification be counted as a transaction?…
-
Continue reading →: The Highest Oracle Certification is not OCP nor OCM, but is …
The highest certification for Oracle databases is not Oracle OCM (Oracle Certified Master). It is, in fact, the Oracle Maximum Availability Certified Master (MACM). To earn this prestigious certification, you must hold five other challenging certifications concurrently. Let’s take Oracle 12c as an example: The journey begins with Oracle Certified…
-
Continue reading →: Can learning Oracle be as simple as reading one book?
Oracle Database is considered one of the most complex technologies in the industry. Mastering Oracle requires extensive and rigorous study. But is there a shortcut? I’ve often been asked, “Yuan, how did you get so good at Oracle?” The truth is, my secret lies in carefully studying one official document:…
-
Continue reading →: My Oracle Certified Master( OCM) Certification Journey, from 10g to 19c.
In 2007, I began my journey to pursue the Oracle Certified Master (OCM) certification. It took me two years of dedicated preparation before I took the 10g OCM exam. During this period, I worked as an Oracle DBA for a foreign bank in Shanghai. The system I maintained were very…
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 