Oracle 12c SQL Performance Tuning

The SQL Tuning Advisor is a powerful built-in Oracle tool that helps you find and fix poorly performing SQL. In this course, you’ll learn how to use it from inside SQL Developer, so you can quickly analyse statements and review suggested improvements. We’ll walk you through how it works, what the different types of advice mean (like creating indexes or rewriting SQL), and how to interpret the results confidently. You’ll leave knowing when to trust the tool and when to go beyond it with your own expertise. 

Hints give you a way to influence how Oracle runs a query. In this session, we look at different types of hints, like those that suggest access methods, join operations, and query transformations, and explain how to use them effectively. You’ll learn how to guide the optimiser without misapplying or overusing hints, and how to combine them with good query design. We’ll also explore when hints are useful for solving specific performance issues, and when they might cause more harm than good in the long term. 

How you structure a query plays a big role in how well it performs. We’ll explore practical ways to improve query design, including simplifying logic, reducing unnecessary joins, and managing views and subqueries. You’ll learn how Oracle handles features like the WITH clause, virtual columns, bind variables and result caching...all of which can impact efficiency. We’ll also look at PL/SQL-related considerations and database settings that influence performance. By the end, you’ll know how to write cleaner, faster SQL that Oracle can optimise more effectively.