With an emphasis on practice alongside theory, this interactive course helps DBAs expand their performance tuning skills for Oracle 12cR2, 18c and 19c databases. Led by Oracle experts, you’ll increase your knowledge through immersive activities in a live lab setting.
Oracle Database 12cR2 DBA Performance Tuning & Management
Optimise your database performance with confidence
In just five focused days, you’ll explore the tools and techniques Oracle DBAs use to tackle performance issues in depth. From tuning tricky SQL queries to managing memory and I/O, this course helps you work faster, smarter and with more confidence, whatever version of Oracle you’re using.
Learning objectives
- Spot and fix performance bottlenecks
- Improve SQL execution with tuning tools
- Manage memory and disk usage effectively
- Use SQL Trace, Explain Plan and Autotrace
- Understand and apply index strategies
- Monitor database health with AWR and ADDM
- Use Oracle’s built-in tuning advisors
- Tune joins, views and complex queries
What you’ll learn
This proactive course breaks down the key technical elements into practical sessions, so you can explore all learning processes in detail to build deeper understanding and technical capabilities. You’ll have the opportunity to investigate real examples, spot common performance problems and fix these with tools Oracle DBAs use every day to keep systems fast and reliable.
SQL tuning tools
Get practical experience with key Oracle SQL tuning tools like Explain Plan, SQL Trace, and Autotrace. These tools help you see how queries are executed, where they’re slowing down, and what to improve. You’ll also explore SQL Developer’s built-in tuning features, making it easier to diagnose poor performance in real time. Whether you’re working with Oracle 12cR2, 18c or 19c, this course shows you how to fine-tune your SQL for better database efficiency and faster results.
Memory and I/O performance
Learn how to optimise Oracle database memory and disk usage for better speed and stability. You’ll tune the Shared Pool, PGA and Buffer Cache, and configure automatic memory management to get the most out of available resources. We’ll also cover techniques to reduce I/O contention and improve response times. This hands-on training will help you understand what’s happening in terms of database performance and give you the knowledge to apply best practices to keep your Oracle DBMS running efficiently, no matter what the circumstances.
Using AWR, ADDM and advisors
Oracle provides powerful tools to monitor and manage performance, and this course covers how to use them effectively. You’ll work with Automatic Workload Repository (AWR) reports, Active Session History (ASH) and the Automatic Database Diagnostic Monitor (ADDM) to identify bottlenecks. You’ll also get the opportunity to become familiar with SQL Tuning Advisor and SQL Access Advisor to troubleshoot problems before they escalate. These tools are key for Oracle DBAs who want to stay ahead of performance issues and improve reliability.
What’s included
- Five days of hands-on, instructor-led training
- Coverage of Oracle 12cR2, 18c and 19c
- Practical labs using real-world scenarios
- Oracle SQL tuning and diagnostics tools
- Access to experienced Oracle-certified trainers
- Digital course materials for ongoing use
- Certificate of attendance
- Post-course support options
- Flexible virtual or on-site delivery
Key facts
Ideal for
DBAs and support engineers who manage Oracle databases and want to get better at performance tuning, troubleshooting and optimisation.
Prerequisites
You should already be confident with Oracle SQL and database administration tasks. Ideally, you’ve completed our Oracle SQL and Oracle 12cR2 Administration courses or have equivalent experience.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one. (Do not change this copy)
FAQs
This Oracle DBA training course focuses on performance tuning for versions 12cR2, 18c and 19c. You’ll build up real-world skills using tools like AWR, ADDM and SQL Tuning Advisor that you can apply in current or future work projects.
How will I learn to tune SQL queries on this course?
We’ll guide you through using tools like Explain Plan, SQL Trace, and Autotrace to identify sluggish or inefficient SQL. You’ll get hands-on practice spotting problem statements, understanding how the Oracle optimiser works, and applying tuning techniques that improve performance. This course is filled with examples you’ll likely come across in a real DBA environment.
What kind of performance issues will I learn to fix?
You’ll cover a wide range, from inefficient SQL and joins to memory bottlenecks and I/O contention. We also look at stats management, index usage, and tools like AWR and ADDM to help you pinpoint and resolve deeper issues. It’s practical, relevant and designed to make you faster at diagnosing and fixing problems.
Can the course focus on the Oracle version my team uses?
Yes, especially if you book it as a closed course. While we cover 12cR2, 18c and 19c, we can tailor the hands-on examples to match the version you’re using day to day, so everything feels more relevant and your team gets the most out of the training.
What our customers say
‘Very well laid out and John does an amazing job of explaining things in detail.’
Ali, Operations Technical Service Analyst – Utilities
‘John made the subject matter interesting. The pacing was spot on and he clearly knew what he was talking about and was able to communicate that easily. Very pleased and would highly recommend.’
Gavin, Government
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