Oracle 11g Release 2 DBA Performance Tuning — A 5 day course

contact usEnquire about this course

Synopsis

This Oracle Database 11g Release 2 DBA Performance & Tuning course introduces the DBA to the main concepts of Oracle Database performance tuning and management. DBAs will gain practical experience in analyzing and tuning database performance.

The Oracle Database 11g Release 2 DBA Performance & Tuning course is suitable for users of Oracle Database 11g and Oracle Database 12c.

Delegates on the Oracle Database 11g Release 2 DBA Performance & Tuning course will learn to identify tuning contentions and how to take corrective action. By the end of the course, delegates will be able to:

Objectives

The objective of the Oracle Database 11g Release 2 DBA Performance & Tuning course is to provide the skills needed to monitor and tune an Oracle Database 11g Release or Oracle Database 12c.

The delegate will practice:

Suitable For

The Oracle Database 11g Release 2 DBA Performance & Tuning course is suitable for database administrators and technical support staff who are required to monitor and tune an Oracle Database 11g Release or Oracle Database 12c.

Follow-on Courses

Prerequisites

A working knowledge of SQL, PL/SQL and Oracle Database administration is required. These skills can be obtained by attendance on the pre-requisite courses:-

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 29 January 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £1945 (+VAT)


Contents

Introduction to Oracle Performance Tuning

Basic Tuning Diagnostics

Identifying Problem SQL Statements

How to Influence the Optimizer

Reduce the Cost of SQL Operations

The SQL Performance Analyser

SQL Performance Management

Tune the Shared Pool

Tune the Buffer Cache

Tune PGA and Temporary Space

Automatic Memory Management

Create and Use Snapshots and Baselines with the Automatic Workload Repository

Define the Scope of Performance Issues

Use Metrics and Alerts

Use AWR-Based Tools

Real Time Database Operation Monitoring

Monitor Applications

Database Replay

Tune Database I/O

A Summary of Oracle Performance Tuning