Oracle Database 11g: SQL Tuning Workshop - Self-Study Course

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

The SQL Tuning Workshop covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Partitioning topics are covered, in addition to taking advantage of hints, bind variables, and different types of indexes.

Learn to:
  • Identify Poorly Performing SQL
  • Understand the Query Optimizer
  • Trace applications
  • Monitor SQL execution in real time
  • Interpret execution plans

Audience
  • Application Developers
  • Data Warehouse Developer
  • Developer
  • Support Engineer
  • Technical…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Data Warehouse, Oracle 11G, PL/SQL, Oracle, and Business Intelligence (BI).

The SQL Tuning Workshop covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Partitioning topics are covered, in addition to taking advantage of hints, bind variables, and different types of indexes.

Learn to:
  • Identify Poorly Performing SQL
  • Understand the Query Optimizer
  • Trace applications
  • Monitor SQL execution in real time
  • Interpret execution plans

Audience
  • Application Developers
  • Data Warehouse Developer
  • Developer
  • Support Engineer
  • Technical Consultant

Course Topics Architecture, SQL Tuning, and Optimization
  • Database Architecture and SQL Tuning
  • SQL Processing and the Optimizer
Indexes, Access Paths, and Join Operations
  • Table Scans, Indexes, Access Paths, and Joins
Execution Plans and Star Transformations
  • Interpreting Execution Plans
  • Understanding Star Transformation
Optimizer Statistics, Hints, and Cursor Sharing
  • Optimizer Statistics
  • Bind Variables, Cursor Sharing, and Optimizer Hints
Application Tracing and Automatic SQL Tuning
  • Application Tracing, Trace Files, and the tkprof Utility
  • Automatic SQL Tuning

Course Objectives
  • Identify problem SQL statements
  • Modify a SQL statement to perform at its best
  • Trace an application
  • Understand how the Query Optimizer makes decisions about how to access data
  • Interpret execution plans
  • Use optimizer hints effectively
  • Generate a load test

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.