Gain practical, hands-on experience with Oracle 19c SQL performance tuning. This course covers key techniques for analysing and improving the efficiency of SQL code, using real-world tools such as explain plans, autotrace, and SQL tuning advisor, helping you optimise Oracle 19c database applications effectively.
Oracle 19c SQL Performance Tuning
SQL Tuning for Oracle 19c databases
This two-day course helps you build the confidence and skills to identify, analyse and resolve SQL performance issues in Oracle database 19c. Learn proven tuning methods and tools that can assist with application efficiency. Ideal for deepening awareness, sharpening understanding and advancing practical capabilities in SQL optimisation.
Learning objectives
- Understand Oracle's SQL tuning process
- Use explain plan to review SQL execution
- Identify and resolve poorly performing SQL
- Optimise queries with indexing strategies
- Analyse SQL using Autotrace and SQL Trace
- Manage statistics with DBMS_STATS
- Use SQL Tuning Advisor in SQL Developer
- Apply hints to influence execution plans
- Improve query efficiency with join operations
- Recognise common performance pitfalls and avoid them
What you’ll learn
You’ll explore practical tools and techniques to get your SQL running better. From reading execution plans to fine-tuning indexes, everything’s designed to help you diagnose and fix performance issues quickly, so your queries run faster, your databases stay lean, and your day-to-day work gets smoother.
SQL optimisation techniques
You’ll dive into the detail of how the Oracle optimiser works and what you can do to guide it. This includes managing statistics, using hints, understanding statement transformation and spotting when your queries are rewritten behind the scenes. You’ll see how adaptive optimisation works in practice and learn how to transfer statistics between databases. It’s all about making sure your SQL runs as efficiently as possible, whatever the environment.
Indexing strategies
Get to grips with how indexes really work and how to use them to your advantage. You’ll learn when and how to apply different types of indexes, from basic B*Tree and composite indexes through to bitmap, function-based and invisible indexes. You’ll also explore index-organised tables and how indexes interact with partitioning. This session will help you avoid the common traps that prevent indexes being used and boost the performance of your queries.
Execution plans and tuning tools
Learn how to read and understand execution plans using tools like EXPLAIN PLAN, Autotrace and SQL Trace. You’ll see how to use these to break down SQL behaviour and uncover what’s slowing your queries down. We also cover the SQL Tuning Advisor in Oracle SQL Developer, so you can get automated tuning suggestions.
What’s included?
- Two days of training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
- Certificate of attendance
Key facts
Ideal for
Ideal for developers, support staff and technical professionals with SQL experience who need to improve the performance of Oracle 19c applications through effective query and database tuning techniques.
Prerequisites
You must have completed the Oracle SQL course before taking this one.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
This immersive, practical course teaches you how to analyse, troubleshoot and optimise SQL in Oracle 19c. Through real-world tools and live exercises, you’ll gain the skills to improve query efficiency and database performance.
What is SQL performance tuning in Oracle 19c?
SQL performance tuning in Oracle 19c involves analysing and improving the execution of SQL queries to enhance database responsiveness. It includes reviewing execution plans, using tuning tools, managing statistics and applying best practices to reduce query execution time.
What tools are used in Oracle SQL tuning?
Key tools include Explain Plan, Autotrace, and SQL Trace, which help you review and understand SQL execution behaviour. You’ll also use the SQL Tuning Advisor through SQL Developer to identify inefficiencies and recommend improvements.
What are SQL hints and how are they used?
SQL hints are directives embedded in queries that influence Oracle’s execution decisions. This course teaches how to apply hints to improve performance and when their use is appropriate within Oracle 19c databases.
Will I learn how to optimise joins in SQL?
Yes, this course explores different join strategies such as nested loop, hash, merge, and others, and shows how each impacts performance. You'll learn when to use each based on data volume and indexing.
What our customers say
"This is now my second course with John at StayAhead and once again the delivery was simply excellent. I was a little bit worried coming in that I wouldn't have the requisite knowledge, however, I found that it was just about the perfect level between being able to understand the concepts and stretching the grey matter. Best fun I've had at work for a while now and would very highly recommend the course to anyone who's taking on more PL/SQL work in their job. Hoping to come back for more in the future!"
Ashley, AppOps Engineer - Government
"Very well laid out and John does an amazing job of explaining things in detail."
Ali, Operations Technical Service Analyst - Utilities
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs