Site icon IT Tutorial

Performance Tuning and SQL Tuning Tutorial in the Oracle Database

I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Database in this article.

 

Performance Tuning and SQL Tuning Tutorial in the Oracle

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.

 

 

 

 

Oracle Performance Tuning

 

Lesson 1- What is Oracle Database Architecture.

Oracle Database Architecture -1 Controlfile, Datafile, SGA and PGA

 

 

Oracle Database Architecture -2 Buffer Cache, Redolog Buffer, Onlinelog and Archivelog

 

 

Oracle Database Architecture -3 SMON, PMON, DBWR,CKPT and LGWR Processes

 

 

 

 

Lesson 2- SQL Statement Processing in Oracle Database

 

SQL Statement Processing in Oracle Database

 

 

 

Lesson 3- Introduction to Performance Management and Tuning

 

Introduction to Performance Management and Tuning in Oracle | Oracle Database Performance Tuning Tutorial -1

 

 

 

 

Lesson 4- Performance Tuning Features and Tools || What is the AWR Report and How to Analyze an AWR Report

 

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

 

What is the Oracle AWR ( Automatic Workload Repository ) Report

 

How to Generate AWR ( Automatic Workload Repository ) Report via SQL*Plus, Enterprise Manager and Toad in Oracle

 

 

 

 

 

How to Read or Analyze an AWR ( Automatic Workload Repository ) Report in Oracle -1

 

 

How to Read or Analyze an AWR ( Automatic Workload Repository ) Report in Oracle -2

 

 

 

 

How to Read or Analyze an AWR ( Automatic Workload Repository ) Report in Oracle -3

 

 

 

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

 

 

 

Oracle Wait Events and Their Solutions in Oracle Database

 

 

 

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

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

 

 

 

 

 

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

 

What is the Execution Plan and How to View Execution Plan in Oracle | Oracle Database Performance Tuning Tutorial -4

 

 

 

Lesson 7- How to Interpret an Execution Plan

How to Read or Interpret an Execution Plan in Oracle | Oracle Database Performance Tuning Tutorial -5

 

 

 

 

 

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

 

How to Use SQL Trace , Trcsess and TKPROF | Oracle Database Performance Tuning Tutorial -6

 

 

 

 

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

 

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

 

 

 

 

 

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

 

Optimizer Access Paths & Join Operators ( Hash Join, Nested Loop ) in Oracle | Oracle Database Performance Tuning Tutorial -8

 

 

 

Lesson 11- What is the SQL Tuning Set and How to Create the SQL Tuning Sets

 

What is the SQL Tuning Set and How to Create the SQL Tuning Sets in Oracle | Oracle Database Performance Tuning Tutorial -9

 

 

 

 

 

Lesson 12- What is the SQL Tuning Advisor and How to Run SQL Tuning Advisor via Manually Enterprise Manager Cloud Control

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

 

 

 

 

How to Run SQL Tuning Advisor via Enterprise Manager Cloud Control | Oracle Database Performance Tuning Tutorial -13

 

 

 

 

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

 

What is the SQL Access Advisor and How to Run SQL Access Advisor | Oracle Database Performance Tuning Tutorial -11

 

 

 

Lesson 14- What is the Automatic SQL Tuning and How to Automated SQL Tuning

 

What is the Automatic SQL Tuning and How to Automated SQL Tuning in Oracle | Oracle Database Performance Tuning Tutorial -12

 

 

 

 

 

 

Lesson 15- SQL Plan Management Using SQL Plan Baselines

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

 

 

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

 

 

 

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

 

SQL Tuning Tutorial

 

Lesson 20- SQL Tuning Tips and Tricks

 

SQL Tuning Tips and Tricks Tutorial in Oracle -1

 

 

 

SQL Tuning Tips and Tricks Tutorial in Oracle -2

 

 

 

SQL Tuning Tips and Tricks Tutorial in Oracle -3

 

 

 

 

Lesson 21- Performance Tuning and Monitoring Scripts for Oracle DBA

 

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

 

Find Blocking Sessions and Kill Locked Session Scripts & Locked Objects | Oracle DBA Scripts All in One -3

 

 

 

 

 

 

 

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

Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

Exit mobile version