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.

Oracle Database Architecture -1

Oracle Database Architecture -2

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

 

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

 

Oracle Database Performance Tuning Tutorial -2 Performance Tuning Features and Tools

What is the Oracle AWR ( Automatic Workload Repository ) Report

How to Generate AWR Report via SQL*Plus, Enterprise Manager and Toad in Oracle

 

How to Analyze an AWR Report in Oracle -1

How to Analyze an AWR Report in Oracle -2

 

How to Analyze an AWR Report in Oracle -3

 

How to Analyze an AWR Report in Oracle -4 TOP SQL

 

Oracle Database Wait Events and Their Solutions

 

 

 

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

Oracle Database Performance Tuning Tutorial -3 What is the Oracle Optimizer and How Cost-Based Optimizer Works ?

 

 

 

 

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

 

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

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

 

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

Oracle Database Performance Tuning Tutorial -7 Optimizer Access Paths (Table and Index Scan)

 

 

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

 

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

 

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

 

Oracle Database Performance Tuning Tutorial -10 What is the SQL Tuning Advisor and How to Run SQL Tuning Advisor Manually

 

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

 

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

 

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

Oracle Database Performance Tuning Tutorial -14 SQL Plan Management Using SQL Plan Baselines

Oracle Database Performance Tuning Tutorial -15 How to Create SQL Plan Baselines Using Enterprise Manager Cloud Control

 

 

Lesson 16- SQL Tuning Tips and Tricks

 

Oracle SQL Tuning Tips and Tricks Tutorial -1

 

Oracle SQL Tuning Tips and Tricks Tutorial -2

 

Oracle SQL Tuning Tips and Tricks Tutorial -3

 

 

Lesson 17- Performance Tuning and Monitoring Scripts for Oracle DBA

 

Oracle DBA Scripts All in One -4 – Performance Tuning and Monitoring Scripts

 

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.

Oracle Database Tutorials for Beginners

Leave a Reply

Your email address will not be published. Required fields are marked *