Docstoc

Oracle Database 10g SQL Tuning Workshop Describe the basic steps

Document Sample
Oracle Database 10g SQL Tuning Workshop Describe the basic steps Powered By Docstoc
					Oracle Database 10g: SQL Tuning Workshop
Duration: 3 Days          Course Code: O10GSQLT


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


Target Audience:
Technical Consultant Forms Developer Java Developer PL/SQL Developer Reports Developer Business Intelligence Developer



Objectives:

 Describe the basic steps in processing SQL statements                   Use the diagnostic tools to gather information about SQL statement
                                                                         processing
 Describe the causes of performance problems
                                                                         Understand Optimizer behavior
 Understand where SQL tuning fits in an overall tuning
 methodology                                                             Influence the optimizer behavior

 Describe Automatic SQL Tuning                                           Influence the physical data model so as to avoid performance
                                                                         problems




Prerequisites:
 Oracle Databas



Content:

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




Further Information:
For More information, or to book your course, please call us on +20 2 2290 2163/2148
training@globalknowledge-eg.com
www.globalknowledge.net/EG

Global Knowledge, 17 Al-Ahram St., Al Korba - Heliopolis, Tower 'B' - 5th Floor, Cairo 11341, Egypt




O10GSQLT                              www.globalknowledge.net/EG             training@globalknowledge-eg.com           +20 2 2290 2163/2148

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:253
posted:3/10/2010
language:English
pages:1
Description: Oracle Database 10g SQL Tuning Workshop Describe the basic steps