ORACLE SQL_TUN_WS | Oracle Database 19c SQL Tuning Workshop
 
This course will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.
This course will help you understand the process of SQL as it is executed in an Oracle Database. You learn to write well tuned SQL statements and utilize tools, such as cost-based optimizer, to execute a more efficient SQL process within an Oracle Database
 
Benefits
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.
 
Role
Database Administrator
 
Course Outline
Module 1: Course Introduction
Module 2: Introduction to SQL Tuning
Introduction to SQL Tuning
Quick Solution Strategy
Practice 2-1: Using SQL DeveloperPráctica 2-1: Uso de SQL Developer
Module 3: Using Application Tracing Tools
Using Application Tracing ToolsUsing Application Tracing Tools
trcsess utilitytrcsess utilidad
Practice 3-1: Tracing Applications (Part 01)Practice 3-1: Application Tracking (Part 01)
Practice 3-1: Tracing Applications (Part 02)Practice 3-1: Application Tracking (Part 02)
Module 4: Optimizer Fundamentals
Optimizer FundamentalsOptimizer Fundamentals
Query Estimator: Selectivity and Cardinality
Plan GeneratorPlan Generator
 
Practice 4-1: Understanding Optimizer Decisions (Optional)
Module 5: Generating and Displaying Execution Plans
Generating and Displaying Execution Plans
AUTOTRACE
Automatic Workload Repository
Practice 5-1: Extracting an Execution Plan by Using SQL Developer
Practice 5-2: Extracting Execution Plans
Module 6: Interpreting Execution Plans and Enhancements
Interpreting Execution Plans and Enhancements
Practice 6-1: Using Dynamic Plans
Module 7: Optimizer: Table and Index Access Paths
Optimizer: Table and Index Access Paths
Indexes: Overview
Bitmap Indexes
Common Observations
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)
Module 8: Optimizer: Join Operators
Optimizer: Join Operators
Practice 8: Using Join Paths
Other Optimizer Operators
Other Optimizer Operators
Practice 9-1: Using the Result Cache
Practice 9-2: Using Other Access Paths (Optional)
Module 9: 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)
Module 10: Using Bind Variables
Using Bind Variables
Cursor Sharing Enhancements
Practice 11-1: Using Adaptive Cursor Sharing
Practice 11-2: Using CURSOR_SHARING (Optional)
Module 11: 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)
Module 12: Workshops
Workshops
Workshop 1: Enhancing the Performance of a SQL Query Statement
Workshop 2: Reviewing the Execution Steps of the SQL Statement
Workshop 3: Learn to Tune Sort Operation Using an Index in the ORDER BY Clauses
Workshop 4: Identifying and Tuning a Poorly Written SQL Statement
Workshop 5: Effects of Changing the Column Order in a Composite Index
Workshop 6: Using Information in the 10053 File to Tune a SQLStatement
Workshop 7: Understanding the Optimizer’s Decision
Workshop 8: Tuning Strategy
Workshop 9: Using SQL Plan Baseline to Manage a Better Execution Plan
 
Descargue el temario para conocer el detalle completo de los contenidos.
 
Debido a las constantes actualizaciones de los contenidos de los cursos por parte del fabricante, el contenido de este temario puede variar con respecto al publicado en el sitio oficial, sin embargo, Netec siempre entregará la versión actualizada de éste.