-
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…
-
Continue reading →: Archived Logs: Why Do They Disappear?
One of my clients reported that some archive logs were not backed up by their backup job. We replicated this issue in a test environment, and here is the process of our experiment. First, we checked the v$archived_log view but couldn’t find the relevant records. We also used RMAN’s LIST…
-
Continue reading →: Solving Excessive Trace File Generation in Oracle: Automating Trace File Deletion with ADR
I work as a database support engineer for a company with 20,000 clients, which means I encounter all kinds of unique issues. One of our clients faced a persistent problem where their database was generating a large number of trace files, frequently filling up the hard disk. Here’s how I…
-
Continue reading →: About Me
Oracle ACE with over 20 years of experience in Oracle and MySQL databases
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 