Oracle Database 11g: Performance Tuning DBA Training

  • Overview
  • Course Content
  • Drop us a Query

Oracle Database 11g: Performance Tuning DBA training demonstrates the skills and knowledge to identify the problems in a database, diagnose properly and fix with an optimized solution. The training describes the Oracle tuning methodology and explains how to use the tools for monitoring and diagnosing SQL and Instance tuning issues. The skills learned during the training will help the participants to optimize database workloads, manage performance, and provide hassle free service with higher quality within the Datacenter.

Upon the completion of the Oracle Database 11g: Performance Tuning training, you will be exhibiting the following skills:

  • Understand and use the Oracle Database tuning methodology and tools
  • Work with the Automatic Workload Repository (AWR) to tune the database
  • Define and use Metrics, Alerts, Baselines, AWR Tools and Services
  • Diagnose and tune common SQL and instance related performance problems
  • Use  Automatic Memory Management to tune the buffer cache, PGA , and temporary space
  • Use Enterprise Manager to monitor the instance performance
  • Use Instance parameters to tune instance components
Target audience
  • Database Designers
  • Database Administrators
  • Support Engineer
  • Technical Consultant
Prerequisites
  • Oracle Database 11g: DBA Track

1. Oracle Database 11g: Performance Tuning Methodology and Tools

  • Introduction to Performance Tuning in Oracle Database 11g
  • Performance Tuning Diagnostics and Tools in Oracle Database 11g

2. Oracle Database 11g: Using AWR and Defining Problems

  • Working with the Automatic Workload Repository (AWR)
  • Defining Problems in Oracle Database 11g

3. Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools and Services

  • Metrics, Alerts, Baselines and Thresholds in Oracle Database 11g
  • Using AWR-Based Tools
  • Configuring, Managing, and Implementing Services

4. Oracle Database 11g: Problem SQL Statements and Oracle Optimizer

  • Identifying Problem SQL Statements
  • Influencing the Oracle Query Optimizer

5. Oracle Database 11g: SQL Performance Management and Database Replay

  • Using SQL Performance Analyzer and SQL Performance Management
  • Using Database Replay

6. Oracle Database 11g: Shared Pool and Buffer Cache Tuning

  • Tuning the Buffer Cache
  • Using Automatic Memory Management

7. Oracle Database 11g: Tuning PGA, Temporary Space, and Automatic Memory Management

  • Tuning PGA and Temporary Space
  • Using Automatic Memory Management

8. Oracle Database 11g: Segment Space, I/O and Performance Tuning

  • Tuning Segment Space Usage
  • Tuning I/O and Performance Tuning

Partners

A Few Things You'll Love!

What our Students Speak

+