Adding Value Consulting
Oracle Database 19c DBA Performance Tuning & Management - 5 days Online Classroom
IT Service & Architecture
Data Analysis

Oracle Database 19c DBA Performance Tuning & Management - 5 days Online Classroom

3.450,00 EUR

  • 5 days
Live Virtual Classroom
Classroom
In House / In Company

Master the techniques used by experienced Oracle DBAs to optimise database performance, eliminate bottlenecks, and maximise system efficiency. The Oracle Database 19c DBA Performance Tuning & Management course provides practical, hands-on training in diagnosing performance issues, tuning SQL statements, optimising memory and storage, and using Oracle's powerful diagnostic tools such as AWR, ADDM, ASH, and SQL Trace. Through real-world labs, you'll learn how to proactively monitor Oracle databases, improve query execution, and apply proven tuning strategies that reduce downtime and support high-performing enterprise environment

Key Features

Language

Course and materials are in English

Level

Intermediate level

5 days (8 hours / day) live classroom

with accredited trainers

60+ recommended study hours

Exercises and solutions

Downloadable PDF documents with detailed content (slides, explanations)

Certificate

Certificate of completion available

Hero

Learning Outcomes

At the end of this course, you will be able to:

Monitor

Learn to use Oracle's built-in performance tools, including AWR, ADDM, ASH, and Performance Hub, to monitor database health and diagnose performance issues.

Analyze

Interpret reports, analyse snapshots and baselines, configure alerts, and use performance metrics to proactively identify and resolve bottlenecks before they impact users.

Develop

Develop the skills to monitor Oracle databases in real time using tools such as DBMS_MONITOR and Active Session History.

Track

Track database sessions, workloads, and active operations, enabling you to quickly detect performance issues, investigate resource usage, and respond effectively to live system activity.

Discover

Discover advanced performance tuning techniques for high-volume Oracle environments.

Explore

Explore automatic indexing, data compression, real-time statistics collection, scalable sequences, bitmap-based functions, and other optimisation features that improve SQL performance, reduce resource consumption, and enhance large-scale database efficiency.

Hero

Course timeline

  1. Day 1: Oracle Performance Tuning Fundamentals

    Lesson 01

    • Understand Oracle performance tuning principles, objectives, and DBA best practices.
    • Develop a structured monitoring strategy with measurable performance goals.
    • Analyse SQL execution using Explain Plan, Autotrace, SQL Trace, and execution plans.
    • Explore the Oracle Optimizer, execution strategies, and statistics management with DBMS_STATS.
    • Learn how sorting operations affect query performance and temporary storage usage.
    • Optimise database performance using effective indexing strategies, access paths, and index tuning techniques.

  2. Day 2: Advanced SQL Optimisation

    Lesson 02

    • Implement advanced indexing techniques, including bitmap, function-based, compressed, and partitioned indexes.
    • Optimise table joins using the most effective join methods and access paths.
    • Analyse and improve SQL performance with SQL Tuning Advisor and SQL Developer.
    • Enhance query efficiency using sequences, views, inline views, and the WITH clause.
    • Control execution plans with Oracle optimizer hints and query transformation techniques.
    • Apply SQL and PL/SQL performance best practices, including result caching, bind variables, and cursor optimisation.

  3. Day 3: Performance Diagnostics and Memory Tuning

    Lesson 03

    • Diagnose database performance issues using Oracle monitoring tools, wait events, and dynamic performance views.
    • Improve SQL efficiency by maintaining indexes, tables, and storage structures.
    • Analyse SQL workloads and compare tuning results using SQL Performance Analyzer.
    • Optimise execution plans with SQL Performance Management, SQL Monitoring, and the SQL Access Advisor.
    • Configure and manage Automatic Memory Management (AMM) and Shared Memory (SGA).
    • Tune the Shared Pool, library cache, and SQL result cache to improve database performance.

  4. Day 4: Oracle Monitoring and Workload Analysis

    Lesson 04

    • Optimise the Database Buffer Cache to improve memory utilisation and query response times.
    • Configure PGA memory and temporary tablespaces for efficient SQL processing.
    • Create and analyse AWR snapshots, reports, and performance baselines.
    • Use AWR, Performance Hub, ADDM, and ASH to identify and troubleshoot performance bottlenecks.
    • Configure metrics, alerts, and thresholds for proactive database monitoring.
    • Monitor performance trends and automate database health analysis using Oracle diagnostic tools.

  5. Day 5: Enterprise Performance Optimisation

    Lesson 05

    • Monitor database operations and application workloads in real time using Oracle monitoring tools.
    • Trace sessions and applications with DBMS_MONITOR to diagnose performance issues.
    • Apply advanced tuning techniques for large-scale databases, including automatic indexing, compression, and real-time statistics.
    • Optimise database I/O performance through storage configuration, ASM, and efficient file management.
    • Improve workload efficiency using scalable sequences, bitmap functions, and SQL optimisation features.
    • Consolidate Oracle performance tuning best practices for memory, storage, statistics, and enterprise database optimisation.
Oracle Database 19c DBA Performance Tuning & Management

Who Should Enroll in this Program?

Oracle Database Administrators (DBAs)

Database Performance Engineers

Oracle Database Support Engineers

Oracle Infrastructure and Operations Specialists

Technical Consultants responsible for Oracle environments

Experienced Oracle professionals looking to strengthen performance tuning expertise

Start course now

Prerequisites

  • A solid understanding of Oracle Database administration
  • Experience working with Oracle SQL
  • Knowledge equivalent to Oracle Database 19c Administration courses
  • Familiarity with Oracle database architecture and management
  • Practical experience administering Oracle databases in production environments

Licensing

and equality policy

Licensing and accreditation

This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.

Equity Policy

AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.

Frequently Asked Questions

Contact background

Need a Custom In-company or Group Training?

Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.