Formation Oracle Database 19c: Performance Management and Tuning

Module 1: Performance Management Overview

Overview of performance management concepts and objectives.

Practice session: Preparing the databases for performance management.

Module 2: Defining Performance Issues

Understanding the scope of performance issues.

Exploring the tuning life cycle phases.

Practice session: Identifying OS issues using Enterprise Manager.

Module 3: Diagnosing Performance with Time Model

Utilizing the time model to diagnose performance issues.

Practice session: Viewing top wait events and the time model data.

Module 4: Using Statistics and Wait Events

Leveraging statistics and wait events for performance diagnosis.

Examining instance activity and wait event statistics.

Practice session: Viewing system statistics and wait events.

Module 5: Monitoring Performance with Log and Trace Files

Utilizing log and trace files for performance monitoring.

Practice session: Viewing performance information in the alert log.

Module 6: Monitoring Performance with Enterprise Manager Cloud Control and SQL Developer

Exploring performance monitoring tools like Enterprise Manager and SQL Developer.

Practice sessions: Monitoring performance using Enterprise Manager and SQL Developer.

Module 7: Viewing Performance Data with Statspack

Introduction to Statspack for viewing performance data.

Practice sessions: Installing Statspack, creating snapshots, and generating reports.

Module 8: Managing Automatic Workload Repository (AWR)

Understanding and managing AWR data in a multitenant environment.

Practice sessions: Creating and managing AWR snapshots, generating and viewing AWR reports.

Module 9: Utilizing Metrics and Alerts

Using metrics and alerts for performance monitoring.

Practice session: Setting up and viewing server-generated alerts.

Module 10: Implementing Baselines

Introduction to baselines for performance monitoring and management.

Module 11: Managing Automated Maintenance Tasks

Overview of managing automated maintenance tasks for performance optimization.

Practice sessions: Configuring automatic maintenance tasks.

Module 12: Analyzing Performance with Automatic Database Diagnostic Monitor (ADDM)

Using ADDM to analyze and diagnose performance issues.

Practice sessions: Identifying performance issues using ADDM tools.

Module 13: Analyzing Performance with Active Session History (ASH) Data

Utilizing ASH data for first-fault system analysis.

Practice session: Generating and reviewing an ASH report.

Module 14: Real-Time Performance Analysis with Emergency Monitoring and Real-Time ADDM

Using emergency monitoring and real-time ADDM for performance analysis.

Module 15: Understanding SQL Statement Processing

Overview of SQL statement processing and execution plans.

Practice session: Using AUTOTRACE and EXPLAIN PLAN.

Module 16: Index Maintenance and Optimization

Maintaining and optimizing indexes for performance improvement.

Practice sessions: Coalescing an index, analyzing the impact of excess blocks.

Module 17: Table Maintenance and Optimization
Managing tables for performance optimization.

Practice sessions: Analyzing segment statistics, using advanced index compression.

Understanding the query optimizer and its behavior.

Practice sessions: Controlling optimizer behavior using initialization parameters.

Module 19: Understanding Execution Plans

Exploring execution plans and their significance.

Practice sessions: Viewing execution plans using SQL TRACE and TKPROF.

Module 20: Managing Optimizer Statistics

Managing optimizer statistics for query optimization.

Practice sessions: Capturing extended statistics, improving statistics collection quality.

Module 21: Using Automatic SQL Tuning

Leveraging automatic SQL tuning for query optimization.

Module 22: Utilizing SQL Plan Management

Understanding and utilizing SQL Plan Management feature.

Module 23: Overview of SQL Advisors

Introduction to SQL advisors for SQL performance tuning.

Module 24: Using the SQL Tuning Advisor

Using the SQL Tuning Advisor for SQL performance improvement.

Module 25: Using the SQL Access Advisor

Leveraging the SQL Access Advisor to improve SQL performance.

Module 26: Overview of Real Application Testing Components

Introduction to Real Application Testing components for performance testing.

Module 27: Using SQL Performance Analyzer

Using SQL Performance Analyzer to determine the impact of changes.

Module 28: Using Database Replay for Performance Testing

Utilizing Database Replay to test system performance.

Module 29: Implementing Real-Time Database Operation Monitoring

Implementing real-time database operation monitoring for performance optimization.

Module 30: Using Services to Monitor Applications

Using services to monitor applications for performance management.

Module 31: Overview of Memory Structures

Understanding memory structures and their management for performance optimization.

Module 32: Managing Shared Pool Performance

Managing shared pool performance for optimal database operation.

Module 33: Managing Buffer Cache Performance

Managing buffer cache performance for improved database performance.

Module 34: Managing PGA and Temporary Space Performance

Managing PGA and temporary space performance for optimal SQL execution.

Module 35: Configuring the Large Pool

Configuring the large pool for optimized memory allocation.

Module 36: Using Automatic Shared Memory Management

Leveraging automatic shared memory management for efficient memory utilization.

Module 37: Introduction to In-Memory Column Store

Overview of in-memory column store feature for performance enhancement.

Module 38: Configuring the In-Memory Column Store Feature

Configuring the in-memory column store feature for improved query performance.

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

Utilizing in-memory column store with various Oracle Database features for enhanced performance.

Module 40: Conclusion and Practice Sessions

Concluding remarks and additional practice sessions for reinforcement.