Module 1: Overview

 Module 2: Defining the Scope of Performance Issues

• Defining the Scope of Performance Issues Objectives
• Tuning Life Cycle Phases

 Module 3: Using the Time Model to Diagnose Performance Issues

 Module 4: Using Statistics and Wait Events to Diagnose Performance Issues

• Using Statistics and Wait Events to Diagnose Performance Issues
• Instance Activity and Wait Event Statistics

 Module 5: Using Log and Trace Files to Monitor Performance

 Module 6: Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance

 Module 7: Using Statspack to View Performance Data

 Module 8: Using Automatic Workload Repository

• Using Automatic Workload Repository
• Managing AWR Data in a Multitenant Environment

 Module 9: Using Metrics and Alerts

 Module 10: Using Baselines

 Module 11: Managing Automated Maintenance Tasks

 Module 12: Using ADDM to Analyze Performance

• Using ADDM to Analyze Performance
• Compare Periods ADDM: Analysis

 Module 13: Using Active Session History Data for First Fault System Analysis

 Module 14: Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues

 Module 15: Overview of SQL Statement Processing

• Overview
• Processing a DML Statement

 Module 16: Maintaining Indexes

• Maintaining Indexes
• Automatic Indexing Task

 Module 17: Maintaining Tables

• Maintaining Tables
• Block Space Management with Free Lists
• Shrinking Segments: Overview
• Advanced Index Compression

 Module 18: Introduction to Query Optimizer

• Introduction
• Using Initialization Parameters to Control Optimizer Behavior

 Module 19: Understanding Execution Plans

• Understanding Execution Plans
• SQL*Plus AUTOTRACE

 Module 20: Viewing Execution Plans by Using SQL Trace and TKPROF

 Module 21: Managing Optimizer Statistics

• Managing Optimizer Statistics
• Extended Statistics

 Module 22: Using Automatic SQL Tuning

 Module 23: Using the SQL Plan Management Feature

 Module 24: Overview of the SQL Advisors

 Module 25: Using the SQL Tuning Advisor

 Module 26: Using the SQL Access Advisor

 Module 27: Overview of Real Application Testing Components

 Module 28: Using SQL Performance Analyzer to Determine the Impact of Changes

 Module 29: Using Database Replay to Test System Performance

• Using Database Replay to Test System Performance
• Database Replay Packages

 Module 30: Implementing Real-Time Database Operation Monitoring

 Module 31: Using Services to Monitor Applications

• Using Services to Monitor Applications
• Creating Services
• Service Aggregation Configuration

 Module 32: Overview of Memory Structures

 Module 33: Managing Shared Pool Performance

• Managing Shared Pool Performance
• Avoid Hard Parses
• Sizing the Shared Pool

 Module 34: Managing Buffer Cache Performance

• Managing Buffer Cache Performance
• Buffer Cache Hit Ratio
• Caching Tables
• Multiple Block Sizes

 Module 35: Managing PGA and Temporary Space Performance

• Managing PGA and Temporary Space Performance
• Monitoring SQL Memory Usage

 Module 36: Configuring the Large Pool

 Module 37: Using Automatic Shared Memory Management

• Using Automatic Shared Memory Management
• Using the V$SYSTEM_PARAMETER View

 Module 38: Introduction to In-Memory Column Store

 Module 39: Configuring the In-Memory Column Store Feature

 Module 40: Using In-Memory Column Store with Oracle Database Features

Oracle Database 19c: Performance Management and Tuning Course Prerequisites:

• Proficiency in Oracle Database technology
• Understanding of SQL
• Knowledge of Oracle Database architecture and deployment
• Previous experience or certification in Oracle Database 12c or 18c
• Familiarity with Oracle Database performance-related features
• Experience managing and tuning Oracle Database performance
• Foundational skills in computer networks and operating systems.