FORGOT YOUR DETAILS?

eluide9eb7f5d

Oracle Database 19c: Performance Management and Tuning

Cost
$5000 USD
Course Code
D107403GC10
Duration
5 Days
Format
Live Virtual Class

Course Schedule

Oracle Database 19c: Performance Management and Tuning

$5,000.00

Scheduled, 12-Sep-2022 - 16-Sep-2022, 09:00 AM - 05:00 PM US Eastern
Scheduled, 28-Nov-2022 - 02-Dec-2022, 09:00 AM - 05:00 PM US Eastern
Scheduled, 06-Feb-2023 - 10-Feb-2023, 09:00 AM - 05:00 PM US Eastern
Choose an option
Oracle Database 19c: Performance Management and Tuning – Scheduled, 12-Sep-2022 - 16-Sep-2022, 09:00 AM - 05:00 PM US Eastern
$5,000.00
Oracle Database 19c: Performance Management and Tuning – Scheduled, 28-Nov-2022 - 02-Dec-2022, 09:00 AM - 05:00 PM US Eastern
$5,000.00
Oracle Database 19c: Performance Management and Tuning – Scheduled, 06-Feb-2023 - 10-Feb-2023, 09:00 AM - 05:00 PM US Eastern
$5,000.00
Clear
SKU: D107403GC10 Categories: , ,

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

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

Related Courses…

TOP
0