Oracle SQL Performance Tuning Masterclass (2026)

This lecture explains what is sql tuning and why we need to perform some tuning techniques

This lecture explains some critical information that you need to know before starting to learn performance tuning

Learning the architecture is really important for performance tuning. This lecture explains why to know it and how much to know among the whole architecture

First part of the architecture overview lecture

Second part of the architecture overview lecture

Data in database are stored in logical data blocks. This lecture explains the Oracle database data blocks in details.

One of the important part of the database architecture is PGA. You need to learn PGA to perform better tuning techniques. This lecture explains PGAs in details.

Shared pool is very critical for parsing performance. This lecture explains shared pool and its sub-memory areas with details.

All the data is processed in the buffer cache. If you know buffer cache, you can perform better tuning techniques. This lecture includes the buffer cache.

Sometimes redo logs decreases the performance. This lecture explains the redo log buffer in the PGA.

As the name implies, undo is for undo. So you will learn how a rollback is done with undo segments

In this SQL Performance and SQL Tuning Tutorial, students will learn SQL Plan Generator.

In this lecture, you will learn the indexes with their structures and working styles

In this lecture, you will see an overview of the table and index access paths

This lecture explain the details of index fast full scan in SQL Performance Tuning

This lecture includes the index skip scan access path in SQL Tuning to improve the performance

This lecture explains the index join scan access path in SQL performance tuning

In this lecture you will see how to use the optimizer hints for SQL Performance Tuning by many examples

In this lecture, you will see an overview of the join methods in SQL Performance Tuning.

This lecture includes the nested loop joins in details in Oracle SQL Performance Tuning

This lecture explains the sort merge join of the join methods in SQL Tuning Aspect

This lecture includes the code samples used in sort merge join lecture, in SQL Performance Tuning Course.

This lecture explains the hash joins for SQL Performance Tuning

This lecture includes the code samples that we used in the hash joins lecture for SQL Performance Tuning

This lecture explains the cartesian joins for SQL Tuning Aspect

This lecture includes the codes used in the Cartesian Joins lecture.

This lecture includes an overview of the join types in SQL Tuning Aspects

This lecture explains the equijoin and nonequijoin join types in SQL Tuning

The examples used in the equijoins and nonequijoins lecture of SQL Tuning

In this lecture, you will see the performance aspects of the outer joins

This lecture explains the antijoins for performance tuning aspect

In this lecture, you will see how to use the result cache on your queries and how to understand it from the execution plans

In this lecture, you will see the clusters in database performance aspects

In this lecture, you will learn how and why the database sorts the rows and how it shows that in the execution plans

In this lecture you will see what does INLIST operator do in the execution plans for on sql tuning perspective

In this lecture you will see what does count stopkey do in the execution plans for on sql tuning perspective

This lecture explains the first row operator in the explain plans with the MIN and MAX functions.

This lecture explains the filter predicate on the explain plans

This lecture explains the concatenation operator in the explain plans and the concatenation hint in the query

This lecture explains the union and union all operators in the execution plans for tuning

In this lecture you will learn the intersect operator and how to tune it

This lecture explains the minus operator in the explain plans and how to tune it in basic

In this lecture, you will learn how to find a performance problem and how to determine a solution for that problem

In this lecture, you will learn how to use the real-time sql monitoring tool via the SQL Developer and the Enterprise Manager

In this lecture, you will learn how to use the real-time sql monitoring tool via the SQL Developer and the Enterprise Manager

In this lecture, you will learn how to use the real-time sql monitoring tool via the SQL Developer and the Enterprise Manager

In this lecture, you will see how to generate the trace files with different methods and how to produce TKRPOF outputs from the trace files. And you will learn how to analyze the TKPROF outputs in details.

In this lecture, you will see how to generate the trace files with different methods and how to produce TKRPOF outputs from the trace files. And you will learn how to analyze the TKPROF outputs in details.

In this lecture, you will see how to generate the trace files with different methods and how to produce TKRPOF outputs from the trace files. And you will learn how to analyze the TKPROF outputs in details.

In this lecture, you will see the select considerations for SQL Tuning aspect

This lecture explains how to make the optimizer use your indexes and increase the performance

This lecture explains the performance effects of the concatenations

This lecture explains the performance problems of using the arithmetic operators

This lecture explains what you should do with like conditions to have a better performance

This lecture explains why to avoid using functions on the indexed columns for SQL Tuning aspect.

This lecture explains how to solve the performance problems of NULL value searches

This lecture explains the performance effects of using Exists instead of IN clause

This lecture explains the performance comparisons of the TRUNCATE and DELETE commands, and some important things you should know for the TRUNCATE operations.

This lecture explains the performance effects of data type mismatches by sql tuning aspect.

This lecture explains how to tune the order by queries for performance

This lecture explains how to tune the order by queries for performance

In this lecture, students are going to learn how to improve the performance of the MIN & MAX queries by sql tuning aspect.

In this lecture, students are going to learn how to improve the performance of the MIN & MAX queries by sql tuning aspect.

This lecture explains the drawbacks of using the having clause in our SQL queries for performance aspect, and how to tune such queries.

This lecture has the code that we used in the related lecture