fbpx

Oracle Database 19c: SQL Tuning Workshop

Nacional
Sob consulta
Sob consulta
Chat

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.

Objetivos

  • 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

Destinatários

This course intended for database developers, DBAs, and SQL developers.

Pré-Requisitos

Oracle Database: Introduction to SQL

Programa

  • Introduction to SQL Tuning
  • Using Application Tracing Tools
  • Optimizer Fundamentals
  • Generating and Displaying Execution Plans
  • Interpreting Execution Plans and Enhancements
  • Optimizer: Table and Index Access Paths
  • Optimizer: Join Operators
  • Other Optimizer Operators
  • Introduction to Optimizer Statistics Concepts
  • Using Bind Variables
  • SQL Plan Management

Introduction to SQL Tuning

  • Introduction to SQL Tuning
  • Quick Solution Strategy

Using Application Tracing Tools

  • Using Application Tracing Tools
  • trcsess Utility

Optimizer Fundamentals

  • Optimizer Fundamentals
  • Query Estimator: Selectivity and Cardinality
  • Plan Generator

Generating and Displaying Execution Plans

  • Generating and Displaying Execution Plans
  • AUTOTRACE
  • Automatic Workload Repository

Interpreting Execution Plans and Enhancements

Optimizer: Table and Index Access Paths

  • Optimizer: Table and Index Access Paths
  • Indexes: Overview
  • Bitmap Indexes
  • Common Observations

Optimizer: Join Operators

Other Optimizer Operators

Introduction to Optimizer Statistics Concepts

  • Introduction to Optimizer Statistics Concepts
  • Column Statistics: Histograms

Using Bind Variables

  • Using Bind Variables
  • Cursor Sharing Enhancements

SQL Plan Management

  • SQL Plan Management
  • Configuring SQL Plan Management
  • Possible SQL Plan Manageability Scenarios

Outras datas e horários

Chat

Quero saber mais informações sobre este curso

Oracle Database 19c: SQL Tuning Workshop

Oracle | 18h - Laboral: 09h30 - 16h30


Notas

Pretende mais informação sobre este curso?

Preencha o formulário com os seus dados e as suas questões e entraremos em contacto consigo para lhe darmos todas as informações pretendidas.

Obrigado!

Quero inscrever-me neste curso

Oracle Database 19c: SQL Tuning Workshop

Oracle | 18h - Laboral: 09h30 - 16h30


Dados Pessoais
Dados para faturação