Oracle SQL Tuning for Developers Workshop (D73549)

This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.
 
Learn To:
  • Interpret execution plans and the different ways in which data can be accessed.
  • Decipher, decide and then apply tuning to SQL code.
  • Use various tuning techniques.
  • Take advantage of bind variables, trace files and use the different types of indexes.
  • Use different access paths for better optimization.
 
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
 
Understand Basic Tuning Techniques
Expert instructors will also teach you how to rewrite queries for better performance. Furthermore, you'll learn how to utilize SQL Tuning Advisor using SQL Developer 3.0.
 
Target Audience
  • Database Designers
  • Developer
  • Data Warehouse Developer
  • PL/SQL Developer
 
Course Objectives
  • 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
Details anzeigen
 
Course Topics
 
Introduction
 
Introduction to SQL Tuning
  • Rewrite the SQL statement
  • Find a workaround to enhance performance
  • Analyze a poorly written SQL statement
  • Create a function based index
  • Redesign a simple table
 
Using SQL Trace Facility and TKPROF
  • Explore a trace file to understand the optimizer’s decisions
 
Understand Basic Tuning Techniques
  • Utilize SQL Tuning Advisor using SQL Developer 3.0
  • Rewrite queries for better performance
  • Rewrite applications for better performance
 
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
  • Use automatic statistics gathering
  • Analyze and use system statistics
 
Using Bind Variables
  • Use the CURSOR_SHARING initialization parameter
  • Use adaptive cursor sharing and bind peeking
 
SQL Plan Management
  • Use SQL Plan Management