Performance Tuning and SQL Tuning Tutorial in the Oracle Database

Hi,

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.

https://ittutorial.org/oracle-database-architecture-1/

https://ittutorial.org/oracle-database-architecture-2/

https://ittutorial.org/oracle-database-architecture-3/

 

 

 

Lesson 2- SQL Statement Processing in Oracle Database

 

SQL Statement Processing in Oracle Database

 

 

 

Lesson 3- Introduction to Performance Management and Tuning

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-1-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

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-2-performance-tuning-features-and-tools/

What is the Oracle AWR ( Automatic Workload Repository ) Report

https://ittutorial.org/awr-report-sqlplus-enterprise-manager-and-toad-how-to-generate-in-oracle/

 

https://ittutorial.org/how-to-analyze-an-awr-report-in-oracle-1/

https://ittutorial.org/how-to-analyze-an-awr-report-in-oracle-2/

 

https://ittutorial.org/how-to-analyze-an-awr-report-in-oracle-3/

 

https://ittutorial.org/how-to-analyze-an-awr-report-in-oracle-4-top-sql/

 

Wait Events and Their Solutions in Oracle Database

 

 

 

Lesson 5- What is the Oracle Optimizer and How Cost-Based Optimizer Works ?

https://ittutorial.org/what-is-the-oracle-optimizer-and-how-cost-based-optimizer-works-oracle-database-performance-tuning-tutorial/

 

 

 

Lesson 6- What is the Execution Plan and How to View Execution Plan

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-4-what-is-the-execution-plan-and-how-to-view-execution-plan/

 

Lesson 7- How to Interpret an Execution Plan

https://ittutorial.org/oracle-database-performance-tuning-tutorial-5-how-to-interpret-an-execution-plan/

 

 

 

Lesson 8-  What is the SQL Trace and How to Use SQL Trace , Trcsess and TKPROF

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-6-how-to-use-sql-trace-trcsess-and-tkprof/

 

 

 

Lesson 9- What is the Index and Optimizer Access Paths (Table Scan and Index Scan)

 

What is an Index ( Advantages and Disadvantages ) in Oracle Database

Index Types and Index Create in Oracle Database

https://ittutorial.org/oracle-database-performance-tuning-tutorial-7-optimizer-access-paths-table-and-index-scan/

 

 

Lesson 10- Optimizer Access Paths & Join Operators ( Hash Join, Nested Loop )

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-8-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

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-9-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

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-10-what-is-the-sql-tuning-advisor-and-how-to-run-sql-tuning-advisor-manually/

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-13-how-to-run-sql-tuning-advisor-via-enterprise-manager-cloud-control/

 

 

Lesson 13- What is the SQL Access Advisor and How to Run SQL Access Advisor

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-11-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

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-12-what-is-the-automatic-sql-tuning-and-how-to-automated-sql-tuning/

 

 

 

 

Lesson 15- SQL Plan Management Using SQL Plan Baselines

https://ittutorial.org/sql-plan-management-using-sql-plan-baselines-oracle-database-performance-tuning-tutorial-14/

https://ittutorial.org/oracle-database-performance-tuning-tutorial-15-how-to-create-sql-plan-baselines-using-enterprise-manager-cloud-control/

 

Lesson 16- Optimizer Hints and How to Use Hints in Oracle

What is the Optimizer Hints and How to Use Hints in Oracle | Oracle Database Performance Tuning Tutorial -16

 

Lesson 17- Automatic Diagnostic Repository Command Interpreter (ADRCI)

Automatic Diagnostic Repository Command Interpreter (ADRCI)

 

Lesson 18- SQL Performance Analyzer and SPA Report in Oracle

What is the SQL Performance Analyzer and SPA Report in Oracle | Oracle Database Performance Tuning Tutorial -17

 

 

Lesson 19- Oracle SQLTXPLAIN (SQLT) Tips and Tricks

Oracle SQLTXPLAIN (SQLT) Tips and Tricks | Oracle Database Performance Tuning Tutorial -18

 

 

Lesson 20- SQL Tuning Tips and Tricks

 

https://ittutorial.org/oracle-sql-tuning-tips-and-tricks-tutorial-1/

 

https://ittutorial.org/oracle-sql-tuning-tips-and-tricks-tutorial-2/

 

https://ittutorial.org/oracle-sql-tuning-tips-and-tricks-tutorial-3/

 

 

Lesson 21- Performance Tuning and Monitoring Scripts for Oracle DBA

 

https://ittutorial.org/oracle-dba-scripts-all-in-one-4-performance-tuning-and-monitoring-scripts/

 

https://ittutorial.org/oracle-dba-scripts-all-in-one-3-blocking-sessions-and-lock-kill-scripts/

 

 

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 10,390 views last month,  446 views today

About Mehmet Salih Deveci

blank
I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply