I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Database in this article.
If you don’t know Performance Tuning and SQL Tuning in the Oracle database and want to learn, you are at the right adress.
You can learn how to improve Oracle database Performance step by step with following steps. I have started Performance Tuning and SQL Tuning Tutorials from beginning, so read each article in order.
This Tutorial post is Guide for Senior Oracle DBA and includes Article links sequential will be updated with new articles.
Lesson 1- What is Oracle Database Architecture.
Lesson 2- SQL Statement Processing in Oracle Database
Lesson 3- Introduction to Performance Management and Tuning
Lesson 4- Performance Tuning Features and Tools || What is the AWR Report and How to Analyze an AWR Report
Lesson 5- What is the Oracle Optimizer and How Cost-Based Optimizer Works ?
Lesson 6- What is the Execution Plan and How to View Execution Plan
Lesson 7- How to Interpret an Execution Plan
Lesson 8- What is the SQL Trace and How to Use SQL Trace , Trcsess and TKPROF
Lesson 9- What is the Index and Optimizer Access Paths (Table Scan and Index Scan)
Lesson 10- Optimizer Access Paths & Join Operators ( Hash Join, Nested Loop )
Lesson 11- What is the SQL Tuning Set and How to Create the SQL Tuning Sets
Lesson 12- What is the SQL Tuning Advisor and How to Run SQL Tuning Advisor via Manually Enterprise Manager Cloud Control
Lesson 13- What is the SQL Access Advisor and How to Run SQL Access Advisor
Lesson 14- What is the Automatic SQL Tuning and How to Automated SQL Tuning
Lesson 15- SQL Plan Management Using SQL Plan Baselines
Lesson 16- SQL Tuning Tips and Tricks
Lesson 17- Performance Tuning and Monitoring Scripts for Oracle DBA