Name: Oracle Database 19c: Performance Management and Tuning
SKU: D107403GC10
Price: 5000.00 USD
Availability: InStock

Oracle Database 19c: Performance Management and Tuning

$5,000.00

SCHEDULED, 27-Nov-2023 - 01-Dec-2023, 09:00 AM - 05:00 PM US Eastern

SCHEDULED, 05-Feb-2024 - 09-Feb-2024, 09:00 AM - 05:00 PM US Eastern

SCHEDULED, 15-Apr-2024 - 19-Apr-2024, 09:00 AM - 05:00 PM US Eastern

SCHEDULED, 09-Sep-2024 - 13-Sep-2024, 09:00 AM - 05:00 PM US Eastern

Class Type

Schedules

TimeZone

Clear

What you will learn

Use the Oracle tuning methodology
Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
Use database advisors to proactively correct performance problems
Identify problem SQL statements
Tune SQL performance problems
Monitor instance performance by using Enterprise Manager
Tune instance components by primarily using instance parameters

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

Overview

What you will learn

Use the Oracle tuning methodology
Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
Use database advisors to proactively correct performance problems
Identify problem SQL statements
Tune SQL performance problems
Monitor instance performance by using Enterprise Manager
Tune instance components by primarily using instance parameters

Audience

Administrator
Database Administrator

Suggested Prerequisites

Oracle Database 19c: Administration Workshop
OracleDatabase 19c: Backup and Recovery

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