Our Oracle Database 18c DBA Performance Tuning & Management course teaches you how to analyse, optimise, and manage database performance. Learn proven tuning methods, SQL optimisation, memory and I/O tuning, and use Oracle tools to ensure high availability and efficiency across 12cR2, 18c, and 19c environments.
Oracle Database 18c DBA Performance Tuning & Management
Optimise Oracle database performance with proven tuning Techniques
Over five days, you will build the expertise to identify, diagnose, and resolve performance bottlenecks. Learn to use Oracle’s advanced tuning tools to analyse SQL execution, optimise memory and storage resources, and implement strategies that ensure peak performance, stability, and availability across enterprise environments.
Learning objectives
- Tune SQL queries and database memory effectively
- Analyse and interpret execution plans
- Optimise SGA and PGA configurations
- Manage disk I/O and data block buffers
- Generate and review AWR and ADDM reports
- Monitor and analyse real-time database operations
- Apply targeted SQL tuning techniques
- Use metrics and alerts for proactive optimisation
What you’ll learn
Gain a comprehensive understanding of Oracle’s core performance tuning and diagnostic tools, learning how to improve SQL execution, monitor system metrics, and optimise memory and storage resources. You'll cover best practices for diagnosing issues, resolving bottlenecks, and implementing performance strategies that keep complex Oracle environments stable, efficient, and highly available.
SQL tuning techniques
Learn how to identify and resolve inefficient SQL in Oracle environments. You’ll use Explain Plan, SQL Trace, and Autotrace to analyse execution paths, manage statistics, and guide the Optimizer’s decisions. You’ll also discover how hints, query transformations, and adaptive optimisation improve performance, enabling you to deliver faster, more efficient database queries.
Memory and resource management
Effective memory tuning is key to overall database performance. In this course, you’ll optimise Oracle’s memory architecture by configuring and tuning the System Global Area (SGA) and Program Global Area (PGA), applying automatic memory management, and fine-tuning shared pool and buffer cache settings. Using memory advisors, you’ll allocate resources efficiently, reduce contention, and sustain stable, high-performing database environments.
Monitoring and diagnostics
Gain in-depth knowledge of Oracle’s diagnostic framework to maintain database health. You’ll work with AWR, ASH, and ADDM to capture snapshots, analyse workload trends, and generate reports. Learn to interpret dynamic performance views, logs, metrics, and alerts, enabling proactive troubleshooting and informed decision-making to prevent performance degradation.
Advanced tuning strategies
Discover how to apply advanced methods for optimising complex Oracle workloads. You’ll use SQL Performance Analyzer and SQL Access Advisor to refine queries, implement specialised indexing, and optimise for large datasets through compression and partitioning. Gain the expertise to address enterprise-level tuning challenges with precision and measurable results.
What’s included
- Five days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
Key facts
Ideal for
Designed for Oracle DBAs and technical support teams who need to monitor and optimise database performance in live environments.
Prerequisites
Prior experience with Oracle SQL and database administration is required. Delegates should be familiar with Oracle built-in packages and basic Linux.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Gain expert-led Oracle performance tuning skills covering versions 12cR2, 18c, and 19c. This course equips you to optimise SQL, memory, and I/O, apply diagnostic tools, and implement best-practice solutions to keep complex enterprise databases running at peak performance.
How does this course support Oracle certification?
This course aligns with the Oracle certification track, covering key topics for exams 1Z0-084 and 1Z0-083. You’ll work with tools like AWR, ADDM, and SQL Performance Analyzer, building practical skills that map directly to exam objectives. While exams aren’t included, the training strengthens knowledge and readiness for certification success.
What diagnostic tools are covered in this course?
You’ll learn to use Oracle’s key diagnostic utilities, including AWR, ASH, ADDM, SQL Trace, Autotrace, SQL Developer, and SQL Performance Analyzer. The course shows you how to capture and interpret performance data, identify bottlenecks, and implement solutions that maintain database responsiveness and stability in real-world environments.
What study options are available for this course?
Our course is available as live virtual classroom training, classroom training, or customised on-site delivery. On-site sessions can be tailored to your organisation’s systems and challenges, ensuring maximum relevance. All formats provide the same comprehensive Oracle performance tuning and diagnostics training experience.
Will the skills from this course apply to Oracle 19c?
Absolutely. While the course content is based on Oracle 18c, the tuning techniques, optimisation strategies, and diagnostic tools, such as AWR, ASH, and memory management are fully compatible with Oracle 19c and 12cR2. The skills gained are directly transferable to modern, legacy, and upgraded environments.
What our customers say
“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, StayAhead Learner - Government
“I have taken a number of virtual training courses over the years and I have to say this one was the best delivery wise. Stuart was engaging and explanatory, extremely patient and no question seemed unimportant or ridiculous.”
Emma, Performance Analyst - Legal
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