Oracle 19c Performance Tuning

Oracle Database: Performance Management and Tuning

Prerequisites

Suggested Prerequisite

• Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
• Familiarity with Oracle Database installation
• Familiarity with Oracle Database configuration concepts

Required Prerequisite

• Oracle Database 18c: Administration Workshop Ed 1
• Basic knowledge of Linux operating system
• A working knowledge of SQL and PL/SQL packages
• Basic understanding of Oracle Database architecture
• Familiarity with basic database monitoring procedures

Audience

• Administrator
• Database Administrator

Topics

• Introduction
• Basic Tuning Diagnostics
• Using Automatic Workload Repository
• Defining the Scope of Performance Issues
• Using Metrics and Alerts
• Using Baselines
• Using AWR-Based Tools
• Real-Time Database Operation Monitoring
• Monitoring Applications
• Identifying Problem SQL Statements
• Influencing the Optimizer
• Reducing the Cost of SQL Operations
• Using SQL Performance Analyzer
• SQL Performance Management
• Using Database Replay
• Tuning the Shared Pool
• Tuning the Buffer Cache
• Tuning PGA and Temporary Space
• Automatic Memory
• Performance Tuning Summary with Waits