Oracle 12c SQL Tuning – the Ultimate Guide

Be one of the top professionals who know how to tune Oracle SQL. When you face a query that starts to be very slow with no apparent reason, you need knowledge and tools to troubleshoot the bottleneck and propose a proper solution; and that is what you will learn in this course.

The course does not only demonstrate the SQL tuning concepts, you will gain hands–on experience on implementing the those concepts as well.

The skills that you will learn in this course include the following:

Troubleshoot SQL statement performance issues

Understand internal optimizer operations

Techniques to influence the optimizer operations:

– SQL profiles,

– SQL plan baselines

– Directives

– SQL Hints

– Cursor Sharing

Use Oracle SQL performance advisory set, including:

– SQL Tuning Advisor

– SQL Access Advisor

– Optimizer Statistics Advisor

– SPM Evolve Advisor

– SQL Performance Analyzer

Use advanced techniques to improve Oracle SQL, like the following:

– histograms

– using the advanced techniques with the indexes

– using server result cache

– star transformation

Content and Overview
Information presented in this course provides the Oracle developers and DBAs the knowledge and experience to perform SQL Tuning activities on Oracle databases.

Through this extensive course, you ll learn all of SQL Tuning on Oracle SQL statements. After every concepts lecture, you will implement a hands–on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video–based demonstrations and the downloadable guide documents.