Oracle 10g SQL Performance Tuning

2 days @ £895.00 exc. VAT

Course Code: O10GSPT

Upcoming Scheduled Events - next 12 months

Location	Start Date	Spaces	Book
London	16 Jul 2018	Limited	Book
London	08 Oct 2018	Spaces	Book
London	17 Dec 2018	Spaces	Book
London	25 Feb 2019	Spaces	Book

View Further Dates

Location	Start Date	Spaces	Book
London	20 May 2019	Spaces	Book

- Guaranteed to Run (StayAhead's Terms & Conditions apply)

T&C's Refer to the Course and Modification section

Virtual Events You can attend your training virtually using the London dates shown above. Those events highlighted with

already have virtual delegates booked. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.

Oracle 10g SQL Performance Tuning Course Overview

This Oracle 10g SQL Performance Tuning course introduces the delegate to the main concepts of Oracle SQL performance tuning. It is designed to give delegates practical experience in analysing and tuning the performance of SQL.

The delegate will learn and acquire skills as follows:

Selecting an Appropriate SQL Tuning Approach
Tuning Database Applications for Optimal Performance
Managing Statistics
Creating and Using Indexes
Structuring SQL Statements for Performance
Examining and Interpreting the Execution Plan of a SQL Statement using EXPLAIN PLAN
Examining the Efficiency of SQL Statements using SQL Trace and Autotrace
Using the SQL Tuning Advisor
Identifying SQL Statements that Perform Badly
Using Hints to Influence Execution Plan
Identifying Unused Indexes

Who will the Course Benefit?

The Oracle 10g SQL Performance Tuning course is designed for SQL programmers, application developers, designers and technical support professionals who are required to tune the performance of an Oracle application running under Oracle Database 10g.

Course Objectives

To provide the skills needed to monitor and tune an Oracle database application.

Requirements

A working knowledge of SQL is required. This can be obtained by attendance on the pre-requisite Oracle SQL course.

Pre-Requisite Courses

Oracle SQL

Follow-On Courses

Notes:

Course technical content is subject to change without notice.
Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

View Course Contents - DAY 1

Oracle 10g SQL Performance Tuning Training Course

Course Introduction

Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE PERFORMANCE TUNING

Overview of Oracle Database Tuning
Application Developer Tuning Responsibilities
Oracle DBA Tuning Responsibilities
Oracle Tuning Process
Plan a Routine Monitoring Regime
Setting Suitable Goals

Session 2: TOOLS FOR EVALUATING SQL STATEMENTS

Overview of SQL Statement Tuning
Tools to Assist in SQL Tuning
Use Explain Plan, Autotrace and SQL Trace to Examine the Execution of a SQL Statement
Interpreting a SQL Trace

Session 3: THE SQL OPTIMIZER

The SQL Optimizer
Statement Transformation
The Optimizer_Mode Initialization Parameter
Cost Based Optimizer
Managing Statistics with DBMS_STATS
Automatic Statistics Gathering
Dynamic Statistics
Online Statistics Gathering for Bulk Loads

Session 4: SORTS

How Oracle Processes Sorts
Temporary Disk Space Assignment
SQL Operations that Use Sorts

Session 5: INDEXES

Index Overview
Selecting Suitable Columns for an Index
B*Tree Indexes
Rebuild an Index
Composite Indexes
Descending Indexes
Access Paths with Indexes
Index Scans
Conditions That Stop Indexes Being Used
Parameters that Affect Optimizer Index Choice

View Course Contents - DAY 2

Oracle 10g SQL Performance Tuning Training Course

Session 6: ADVANCED INDEXES

Bitmap Indexes
Key Compressed Indexes
Index Organized Tables
Function Based Indexes
Invisible Indexes

Session 7: JOIN OPERATIONS

Understand Access Paths
Joining Tables
Nested Loops Join
Merge Join
Cluster Join
Hash Join
Anti Join and Semi Join
Outer Joins
Star Join
Improve Optimization with Different Access Paths

Session 8: SQL TUNING ADVISOR USING SQL DEVELOPER

Overview of the DBMS_SQL_TUNE Package
Using the SQL Tuning Advisor with SQL Developer

Session 9: SEQUENCES AND VIEWS

Sequence Caching
Views
View Merging
Inline Views

Session 10: USING HINTS

Session 11: MISCELLANEOUS

Home Let Us Call You Enquiry

Place A booking

97.35%
Instructor
Quality
Rating

92.54%
Course
Practical
Rating

94.35%
Overall
Courseware
Rating

96.29%
Overall
Course
Rating

Print Friendly

97.35%
Instructor
Quality
Rating

96.29%
Overall
Course
Rating

Course Reviews

I had high hopes for the course, when I read the topics to be covered, and I believe that it covered the content very well. The trainer was extremely knowledgeable and was able to help with our specific queries related to our own location. Thanks for that.

Elaine - Analyst Developer

Excellent instructor, very knowledgeable and interesting course work.

Dave - Application Developer /Support

Excellent instructor with a lot of knowledge and experience. Excellent content.

Lee - Application consultant

More Course Reviews....

From the moment Brian starts you can tell he is clearly very knowledgable and passionate about the subject matter. He makes the effort to explain things clearly and simply, and takes time to answer question as and when they arise. Thank you.

Don - Management Information Analyst

Book further course dates

London dates View London dates

London Venue

View London location details

StayAhead Locations

Request a Centre .......

If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or sales@stayahead.com to enquire if we can accommodate your venue requirements.