Oracle Database 10g: SQL Tuning Workshop

Overview

  • Describe the basic steps in processing SQL statements
  • Describe the causes of performance problems
  • Understand where SQL tuning fits in an overall tuning methodology
  • Describe Automatic SQL Tuning
  • Use the diagnostic tools to gather information about SQL statement processing
  • Understand Optimizer behavior
  • Influence the optimizer behavior
  • Influence the physical data model so as to avoid performance problems

Days:

Course Code:

3

O10GSQLT

Pre-Requisites


  • Oracle Databas
Content


  • Database Architecture overview
  • Following a Tuning Methodology
  • Designing Applications for performance
  • Introducing the optimizer
  • Optimizer Operations
  • Displaying Execution plans
  • Gathering Statistics
  • Application Tracing
  • Identifying High Load SQL
  • Automatic SQL Tuning
  • Introduction to Indexes
  • Advanced Indexes
  • Optimizer Hints and Plan Stability
  • Materialized Views and Temporary Tables
Objectives


  • Describe the basic steps in processing SQL statements
  • Describe the causes of performance problems
  • Understand where SQL tuning fits in an overall tuning methodology
  • Describe Automatic SQL Tuning
  • Use the diagnostic tools to gather information about SQL statement processing
  • Understand Optimizer behavior
  • Influence the optimizer behavior
  • Influence the physical data model so as to avoid performance problems
Target Audience


  • Technical Consultant
  • Forms Developer
  • Java Developer
  • PL/SQL Developer
  • Reports Developer
  • Business Intelligence Developer
vendors Course Code Course Title Days Date
Oracle Certifications in UAE
O10GSQLT Oracle Database 10g: SQL Tuning Workshop 3 View All Dates

This public courses are pre-scheduled throughout the year at our premises

Online, live and interactive training accessible from anywhere

We can deliver standard or customised training at any time and location that suits your employees

Guaranteed courses are confirmed to run on the specific dates shown