Discover how to improve Oracle database efficiency and reliability with the Oracle Database 18c DBA Performance Tuning & Management course. Develop skills in SQL tuning, memory and I/O optimisation, and use Oracle performance tools to enhance availability across versions 12cR2, 18c, and 19c.
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25USA
View courses
925e9aaf-8b13-4938-af1e-96e9300bffdf
Oracle Database 18c DBA Performance Tuning & Management
Select your learning method
Learn essential skills
Course overview
Enhance Oracle database performance with targeted tuning skills
Gain the capabilities to assess, fine-tune, and maintain optimal Oracle database performance during our five-day course. Through applied learning, you’ll work with SQL tuning, memory optimisation, and I/O management techniques, helping you ensure system stability, efficiency, and responsiveness within demanding business environments.
Learning objectives
- Optimise SQL queries and database memory allocation
- Analyse and interpret execution plans for performance insights
- Configure and tune SGA and PGA memory components
- Improve disk I/O throughput and buffer cache usage
- Produce and analyse AWR and ADDM performance reports
- Monitor real-time workload and system activity
- Apply SQL tuning advisors and performance analysis utilities
- Use metrics and alerts to maintain proactive system health
What you’ll learn
Develop the skills to use Oracle’s key performance tuning and diagnostic utilities to boost database efficiency. Learn to enhance SQL performance, track and analyse critical metrics, and fine-tune memory and storage resources. Discover proven techniques for troubleshooting, removing bottlenecks, and sustaining high availability across demanding enterprise environments
Streamlining SQL execution
Learn techniques to ensures Oracle SQL runs more efficiently, from pinpointing costly operations to refining query structures. You’ll explore indexing strategies, evaluate alternative execution paths, and fine-tune database interactions to improve throughput, reduce latency, and keep applications responsive under high-demand workloads.
Maximising database efficiency
Understand how to balance memory, CPU, and I/O usage for consistent Oracle database performance. This includes adjusting resource parameters, monitoring utilisation patterns, and applying targeted improvements. You’ll also develop the capability to keep systems stable, even as workloads grow and operational demands increase.
Ensuring performance stability
Discover how to keep Oracle environments running at peak capability by detecting and addressing issues early. You’ll work with performance data, track trends, and implement solutions that prevent slowdowns. The focus is on proactive management to maintain availability and reliability for critical business services.
Real-Time monitoring and tuning
Learn to monitor and optimise Oracle database performance in real time, ensuring stability under high-demand workloads. Use Performance Hub, SQL Monitor, and DBMS_Monitor to track active sessions and trace operations. Explore advanced features for big data and data warehousing, including automatic indexing, scalable sequences, and real-time statistics, enabling proactive tuning and sustained enterprise-scale performance.
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
Built for DBAs and IT teams responsible for Oracle database efficiency and looking to expand tuning capabilities.
Prerequisites
Participants should be confident using Oracle SQL and have experience managing Oracle databases. Some Linux familiarity is helpful.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Develop practical Oracle performance tuning expertise for enterprise environments during this course. You’ll learn proven methods for SQL optimisation, diagnostics, and system monitoring. You'll also be able to apply Oracle’s tuning tools effectively to keep business-critical databases stable, efficient, and high performing.
Does the course cover performance tuning for large datasets?
Yes. The course addresses tuning strategies for large datasets and data warehouses, including advanced indexing, partitioning, compression, and optimising queries for high-volume operations. You’ll also explore real-time monitoring techniques to sustain performance during intensive reporting or analytics workloads.
Does this Oracle tuning course support certification?
Yes. This Oracle Database 18c Performance Tuning & Management course aligns with the skills assessed in exams 1Z0-083 and 1Z0-084. You’ll practise using tools like ADDM and SQL Performance Analyzer in realistic scenarios, building both technical expertise and the confidence needed for Oracle certification success.
Will I learn how to use Oracle SQL Performance Analyzer?
Absolutely. You’ll gain practical knowledge of SQL Performance Analyzer for assessing workload changes, comparing execution plans, and validating performance improvements before deployment. Ensuring that tuning changes enhance system efficiency without introducing risk to production environments.
How technical is this Oracle performance tuning course?
This advanced Oracle Database Performance Tuning & Management course is for DBAs with experience in Oracle administration and SQL. Building on skills including schema management and SQL scripting, it covers memory optimisation, SQL diagnostics, and system-level metrics within an immersive live lab environment.
What our customers say
“The training was absolutely fantastic. Hats off to the trainer John.”
omon, Senior Specialist Engineer SRE – Government
“Always good courses from StayAhead. Tutor explained the course very well.”
Paul, Development Analyst, Application Support - Transport
Why study with ILX
500,000+ learners
Join the half a million learners developing their skills with our training
5,000+ businesses
A trusted partner to thousands of organisations worldwide
96% customer satisfaction
Our passionate team goes above and beyond to support customer needs
Quote request
Please complete the form to ensure your quote is accurate and we will contact you soon.
For the best prices, get in touch!