Oracle Database 11g: SQL Tuning Workshop

The SQL Tuning Workshop class 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.

Doelgroep

Technisch consultant.

Voorkennis

ORSQL1101: Oracle Database 11g: Introduction to SQL.

Inhoud

• Introduction
• Oracle Database Architecture Overview
• Introduction to the Query Optimizer
• Query Optimizer Operations
• Interpreting Execution Plans
• Workshop1: Observing the Optimizer's Plans
• Writing Efficient SQL
• Workshop 2: Tracing and Tuning SQL
• Using Bind Variables
• Application Tracing
• Workshop 3: Tracing and Tuning an Application
• Understanding Query Optimizer Decisions
• Using Optimizer Hints
• Workshop 4: Optimizer hints
• Workshop 5: Corrective action
• Applying a Performance-Centered Methodology
• Additional Tuning Methods
• Workshop 6: Other methods

• Gratis brochure aanvragen
• Contact opnemen