Formation SQL TUNING POUR LES DÉVELOPPEURS ORACLE 12C ED2

• SQL Tuning Session
• SQL Tuning Strategies
• Development Environments: Overview
• SQLTXPLAIN (SQLT) Diagnostic Tool

• Using the SQL Trace Facility: Overview
• Steps Needed Before Tracing
• Available Tracing Tools: Overview
• The trcsess Utility
• Formatting SQL Trace Files: Overview

• Developing Efficient SQL statement
• Scripts Used in This Lesson
• Table Design
• Index Usage
• Transformed Index
• Data Type Mismatch
• NULL usage
• Tune the ORDER BY Clause

• SQL Statement Representation
• SQL Statement Processing
• Why Do You Need an Optimizer?
• Components of the Optimizer
• Query Transformer
• Cost-Based Optimizer
• Adaptive Query Optimization
• Optimizer Features and Oracle Database Releases

• Execution Plan?
• The EXPLAIN PLAN Command
• Plan Table
• AUTOTRACE
• V$SQL_PLAN View
• Automatic Workload Repository
• SQL Monitoring
• DBML_SQL_MONITOR

• Interpreting a Serial Execution Plan
• Adaptive Optimizations
• Optimizer: Table and Index Access Paths
• Row Source Operations
• Main Structures and Access Paths
• Full Table Scan
• Indexes
• Common Observations

• Join Methods
• Join Types

• Other Optimizer Operators
• SQL operators
• Other N-Array Operations
• Result Cache operators

• Optimizer Statistics
• Types of Optimizer Statistics
• Gather and Manage Optimizer Statistics: Overview

Cursor Sharing and Different Literal Values
Cursor Sharing and Bind Variables

• Maintaining SQL Performance
• SQL Plan Management

• Workshop 1
• Workshop 2
• Workshop 3
• Workshop 4
• Workshop 5
• Workshop 6 & 7
• Workshop 8
• Workshop 9