SQL Tuning for Developers Workshop NEW

Course Fees: $3219.00 excl. GST
Printed Manual: $105.00 excl. GST
Course Duration: 3 days
Course Manual

Sorry, no course dates found

Students learn to interpret execution plans and the different ways in which data can be accessed.

Students are shown how to decipher, decide and then apply tuning to their SQL code. Various tuning techniques are demonstrated. For example, taking advantage of bind variables, trace files, and using the different types of indexes are utilized.
Data Warehouse Developer
Database Designers
Developer
PL/SQL Developer
Oracle Database: SQL Fundamentals I Oracle Database: Introduction to SQL Oracle Database: SQL Fundamentals II
Choose an appropriate SQL tuning approach
Gather and interpret session statistics using the SQL trace facility
Identify the SQL statements that perform poorly
Use tuning techniques to tune inefficient SQL statements
Interpret Execution Plans
Describe the Oracle optimizer fundamentals
Manage SQL performance through changes
Introduction

Introduction to SQL Tuning
Find a workaround to enhance performance
Analyze a poorly written SQL statement
Create a function based index
Redesign a simple table
Rewrite the SQL statement

Using SQL Trace Facility and TKPROF
Explore a trace file to understand the optimizer’s decisions

Understand Basic Tuning Techniques
Rewrite queries for better performance
Rewrite applications for better performance
Utilize SQL Tuning Advisor using SQL Developer 3.0

Optomizer Fundamentals
Explore a trace file to understand the optimizer’s decisions

Understanding Serial Execution Plans
Use different techniques to extract execution plans
Use SQL monitoring

Optimizer: Table and Index Access Paths
Learn about using different access paths for better optimization

Optimizer: Join Operations
Use different access paths for better optimization
Examine and use the result cache

Other Optimizer Methods
Use different access paths for better optimization
Examine and use the result cache

Optimizer Statistics
Analyze and use system statistics
Use automatic statistics gathering

Using Bind Variables
Use adaptive cursor sharing and bind peeking
Use the CURSOR_SHARING initialization parameter

SQL Plan Management
Use SQL Plan Management