Oracle Database 11g: Performance Tuning

Oracle Database 11g: Performance Tuning

In this course, you will learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components.

Throughout the course, you will practice the art of tuning an Oracle Instance through a series of workshops.  It will also make use of many features that require the Enterprise Edition and optional Packs.

Suggested Prerequisite

  • Oracle Database: SQL and PL/SQL Fundamentals

Required Prerequisite

  • Oracle Database 11g: Administration Workshop II
  • Oracle Database 11g: Administration Workshop I

You will learn how to:

  • Use Database Statistics and Metrics to identify a performance problem
  • Interpret Tuning diagnostics
  • Identify and eliminate performance issues
  • Set tuning priorities and strategies
  • Identify problem SQL statements
  • Influence the optimizer

This course covers the following;

  • Monitoring With Basic Tools
  • Using Automatic Workload Repository
  • Identifying the Problem
  • Identifying Problem SQL Statements
  • Influencing the Optimizer
  • SQL Plan Management
  • Change Management
  • Using Metrics and Alerts
  • Using AWR Based Tools
  • Monitoring an Application (Using Services)
  • Baselines
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Tuning PGA and Temporary Space
  • Automatic Memory Management
  • Tuning Block Space Usage
  • Tuning I/O,: Performance Tuning: Summary,Using Statspack

This course prepares you for the following Certifications

  • Oracle Database 11g Administrator Certification

What next?

  • Oracle Database 12c: Install and Upgrade Workshop
  • Oracle Database 12c: Backup & Recovery Workshop
  • Oracle Database 12c: Managing Multitenant Architecture

How you will be assessed?



7th Feb 2020


7th March 2020


7th Sept 2020

E-learning Portal