ie.nexushuman.com
Phone Email
Home / Courses / AI, Data & Analytics / Oracle Database: Performance Management and Tuning

Oracle Database: Performance Management and Tuning

- Introduction<br>- Basic Tuning Diagnostics<br>- Using Automatic Workload Repository<br>- Defining the Scope of Performance Issues<br>- Using Metrics and Alerts<br>- Using Baselines<br>- Using AWR-Based Tools<br>- Real-Time Database Operation Monitoring<br>- Monitoring Applications<br>- Identifying Problem SQL Statements<br>- Influencing the Optimizer<br>- Reducing the Cost of SQL Operations<br>- Using SQL Performance Analyzer<br>- SQL Performance Management<br>-...

  • 4.6 out of 5 rating
  • Last updated : 23/07/2026
  • English

Available as Instructor Led Training, Live Online & In Person at your Offices or Ours.

Oracle Database: Performance Management and Tuning
Enquire Now Download Download Overview

Duration:

40.00 hours

32.5 CPD hours

Overview:

- 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

Description:

- 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
DURATION 1 Day

No scheduled classes available at this time.

bg

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable.

To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.