Oracle Database 19C: SQL Tuning Workshop

Prerequisiti obbligatori:

• Oracle Database: Introduction to SQL

Prerequisiti suggeriti :

• Oracle Database: SQL Fundamentals I

Recommended Related Training Courses:

• Oracle Enterprise Manager 11g: Grid Control Essentials
• Parallel Processing in Oracle Database 11g - Seminar
• Oracle SQL Tuning for Developers Workshop NEW

Il corso è consigliato per:

• Amministratore di database
• Amministratore di datawarehouse
• Sviluppatori di applicazioni
• Sviluppatore PL/SQL

• Identify poorly performing SQL
• Trace an application through its different levels of the application architecture
• Understand how the Query Optimizer makes decisions about how to access data
• Define how optimizer statistics affect the performance of SQL
• List the possible methods of accessing data, including different join methods
• Modify a SQL statement to perform at its best 

1: Course Introduction

Course Introduction

Workshop 1: Enhancing the Performance of a SQL Query Statement

 2: Introduction to SQL Tuning

Introduction to SQL Tuning

Quick Solution Strategy

Workshop 2: Reviewing the Execution Steps of the SQL Statement

Practice 2-1: Using SQL Developer

3: Using Application Tracing Tools

Using Application Tracing Tools

trcsess Utility

Workshop 3: Learn to Tune Sort Operation Using an Index in the ORDER BY Clauses

Practice 3-1: Tracing Applications (Part 01)

Practice 3-1: Tracing Applications (Part 02)

4: Optimizer Fundamentals

Optimizer Fundamentals

Query Estimator: Selectivity and Cardinality

Plan Generator

Workshop 4: Identifying and Tuning a Poorly Written SQL Statement

Practice 4-1: Understanding Optimizer Decisions (Optional)

 5: Generating and Displaying Execution Plans

Generating and Displaying Execution Plans

AUTOTRACE

Automatic Workload Repository

Workshop 5: Effects of Changing the Column Order in a Composite Index

Practice 5-1: Extracting an Execution Plan by Using SQL Developer

Practice 5-2: Extracting Execution Plans

 6: Interpreting Execution Plans and Enhancements

Interpreting Execution Plans and Enhancements

Workshop-6: Using Information in the 10053 File to Tune a SQL Statement

Practice 6-1: Using Dynamic Plans

 7: Optimizer: Table and Index Access Paths

Optimizer: Table and Index Access Paths

Indexes: Overview

Bitmap Indexes

Common Observations

Workshop 7: Understanding the Optimizer’s Decision

Practice 7-1: Using Different Access Paths (Part 01)

Practice 7-1: Using Different Access Paths (Part 02)

Practice 7-1: Using Different Access Paths (Part 03)

Practice 7-1: Using Different Access Paths (Part 04)

 8: Optimizer: Join Operators

Optimizer: Join Operators

Workshop 8: Tuning Strategy

Practice 8: Using Join Paths

 9: Other Optimizer Operators

Other Optimizer Operators

Workshop 9: Using SQL Plan Baseline to Manage a Better Execution Plan

Practice 9-1: Using the Result Cache

Practice 9-2: Using Other Access Paths (Optional)

 10: Introduction to Optimizer Statistics Concepts

Introduction to Optimizer Statistics Concepts

Column Statistics: Histograms

Session-Specific Statistics for Global Temporary Tables

Practice 10-1: Index Clustering Factor

Practice 10-2: Creating Expression Statistics

Practice 10-3: Enabling Automatic Statistics Gathering Optional (Part 01)

Practice 10-3: Enabling Automatic Statistics Gathering Optional (Part 02)

Practice 10-4: Using System Statistics (Optional)

 11: Using Bind Variables

Using Bind Variables

Cursor Sharing Enhancements

Practice 11-1: Using Adaptive Cursor Sharing

Practice 11-2: Using CURSOR_SHARING (Optional)

 12: SQL Plan Management

SQL Plan Management

Configuring SQL Plan Management

Possible SQL Plan Manageability Scenarios

Practice 12-1: Using SQL Plan Management SPM (Part 01)

Practice 12-1: Using SQL Plan Management SPM (Part 02)

 13: Workshops