Oracle Performance Tuning for DBAs

Duration: 
3 days

Overview

This course is highly interactive and consists of theory coupled with plenty of practical sessions.

Together with Oracle SQL, this course provides the perfect prerequisite knowledge to embark on training for PL/SQL Programming, or administrative roles such as Oracle Database Administration.

End users and developers can do much to get the best out of their system without necessarily involving the DBA.

After completion of the course each delegate should know the following:

  • How to monitor how Oracle runs an SQL script and identify problem areas
  • How the Oracle query optimiser uses the data dictionary
  • How to explore and implement better querying access paths

Audience

This course is ideal for:

  • Database administrators.
  • Developers.
  • Power end users proficient in basic SQL.
  • Data warehouse support teams.
  • First line support.
  • BusinessObjects "managers".
  • SQL support staff.
  • Central Oracle support team members.

Prerequisites

Attendees should be knowledgeable in Oracle Database Administration (at version 10G minimum) to get the best out of this course.

This course is available on site only. Please call for details.

Course Outline

  • Overview
  • Common causes of performance problems
  • Strategies & methodologies
  • Diagnostic tools
  • Tracking SQL
  • Interpretation of EXPLAIN PLAN
  • Interpretation of AUTOTRACE
  • Reading and configuring SQL TRACE output
  • Tables
  • Use of column datatypes
  • Use of constraints
  • Use of different storage techniques
  • Different table access types in EXPLAIN PLAN & AUTOTRACE
  • Indexes
  • Use of different index types
  • Different index access types in EXPLAIN PLAN & AUTOTRACE
  • Effects of different SQL expressions on index usage
  • SQL Construction & Design
  • Different ways of defining joins
  • Different ways of defining WHERE clauses
  • Different ways of minimizing overheads or parsing and executing SQL
  • Effects of non-summary functions
  • Effects of Wildcards
  • Implicit Data Type Conversion
  • NULL values
  • Negations
  • Variations in the ORDER BY clause
  • Variations in aggregation functions
  • Variations in subqueries
  • Data Dictionary
  • Interpretation of table statistics
  • Interpretation of index statistics
  • Use of histograms

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
California
Los Angeles3 2400 $2400 2019-02-20
Texas
Houston3 2400 $2400 2019-02-20
Onsite
Onsite3 2400 $2400 2019-03-17
Onsite
Onsite2 1600 $1600 2019-03-17