Oracle Database 12c DBA Performance Tuning and Management — A 5 day course

contact usEnquire about this course

Syllabus

This Oracle Database 12c DBA Performance Tuning & Management 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 12c DBA Performance Tuning & Management course is suitable for users of Oracle Database 11g and Oracle Database 12c.

Delegates on the Oracle Database 12c DBA Performance Tuning & Management 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 12c DBA Performance Tuning & Management course is to provide the skills needed to monitor and tune an Oracle Database 12c or Oracle Database 11g.

The delegate will practice:

Suitable For

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

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 Oracle SQL, Oracle PL/SQL and Oracle Database Administration courses:-


Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 26 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

Tools for Evaluating SQL Statements

The SQL Optimizer

Sorts

Indexes

Advanced Indexes

Join Operations

SQL Tuning Advisor Using SQL Developer

Sequences and Views

Using Hints

Miscellaneous

Basic Tuning Diagnostics

Reduce the Cost of SQL Operations

The SQL Performance Analyzer

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