Gain the practical skills to diagnose and resolve performance issues in Oracle Database 19c. You’ll learn how to set tuning goals, analyse SQL execution plans, manage statistics, and use Oracle’s built-in tools including AWR, SQL Trace, and tuning advisors.
Oracle Database 19c DBA Performance Tuning & Management
Tune databases with confidence and precision
Over five days, you'll learn how to spot and fix performance issues in Oracle databases, building the awareness, understanding and practical capability needed to keep systems running at their best. The course enhances your ability to manage Oracle environments, making you a more effective and valuable DBA.
Learning objectives
- Spot performance problems early
- Fine-tune SQL statements
- Use tools like SQL trace and autotrace
- Get to grips with database stats
- Tweak memory and storage settings
- Work with AWR and ADDM reports
- Understand execution plans
- Optimise PGA and SGA
- Break down wait events
- Follow performance tuning best practice
What you’ll learn
Dive into real-world performance tuning, from speeding up slow SQL to improving how memory and storage behave. You’ll use Oracle’s diagnostic tools, understand how to monitor performance, and learn how to fix problems before they escalate.
Performance diagnostics
Learn how to diagnose performance issues before they impact your users. Explore key dynamic performance views, wait events, time models, and logs to get insight into the inner workings of your database. We'll show you how to use the SQL Performance Analyser to assess the impact of changes, capture tuning sets, and compare results, all of which contributes to more informed decision-making.
SQL tuning techniques
Develop a strong understanding of SQL tuning by learning how to use tools such as Explain Plan, Autotrace and SQL Trace to examine execution behaviour in detail. Learn how to identify inefficient SQL statements, apply appropriate indexing strategies, and use hints to influence the optimiser’s decisions. The course also introduces SQL rewriting techniques and provides guidance on analysing statement performance to identify and address execution bottlenecks, enabling more consistent and efficient query performance.
Memory and storage tuning
Discover how to maximise your Oracle memory and storage setup. You'll learn how to configure and tune memory components like the PGA, SGA, and buffer cache, along with strategies for automatic memory management. We’ll also cover tuning the shared pool, using memory advisors, managing temporary space and reducing I/O contention, so your systems remain responsive and efficient.
What’s included
- 5 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
Key facts
Ideal for
DBAs and technical support staff responsible for the performance and operation of Oracle databases.
Prerequisites
You should have practical knowledge of using SQL and administering an Oracle database, as taught on our Oracle SQL and Oracle Database 19c Administration courses.
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 course teaches you how to monitor, diagnose, and improve the performance of Oracle Database 19c using its built-in tuning and diagnostic tools.
Is this course suitable for Oracle 12c or 18c?
Absolutely. The course is designed to help you work confidently with Oracle 12cR2, 18c and 19c. Whether you're looking after an older environment or moving up to the latest release, we’ll teach you the tools you need. You'll learn what changes with each version, and how to tweak your approach to get the best out of your database, whichever version you're working with.
Will I gain practical experience using tools like AWR and ADDM?
Yes, the course includes hands-on exercises using tools such as AWR and ADDM. You’ll gain practical experience in generating and interpreting performance reports, enabling you to apply what you’ve learned in real-world Oracle environments.
Will this course help me with Oracle certification?
Yes, when combined with a selection of our other courses including Oracle Database 19c Install & Upgrade, Oracle Multitenant Administration, and Oracle Database 19c Backup and Recovery with RMAN this training will help you prepare for the following certifications:
- Oracle Database Administration II: 1Z0-083
- Oracle Database 19c, Performance Management and Tuning: 1Z0-084
Before taking the exam, ensure you meet all prerequisite requirements. These are available on the Oracle website.
NOTE: The exam is not included with this course.
What our customers say
“Good structure to the course. Each technical aspect was broken down by the instructor and theory was explained with practical examples, which aided understanding and provided guidance on best practice when applying in real life scenarios. Thanks for an informative and enjoyable course. I feel like I've learnt a lot over the last few days.”
Ross, Government
"Always good courses from StayAhead. Tutor explained the course very well."
Paul, Development Analyst, Application Support - Transport
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