Oracle Database 19c: SQL Tuning Workshop

ORA-19c-SQLT Új

Képzési forma:
Képzés hossza:
3 nap (24 óra)
Képzés nyelve:
Magyar/Angol
Képzési forma:
Normál
Képzés hossza:
3 nap (24 óra)
Képzés nyelve:
Magyar/Angol

Ismertető

Oracle Database 19c SQL Tuning Workshop

This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.

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.

Outline:

  • Course introduction
  • Introduction to SQL Tuning
  • Using application Tracing Tools
  • Optimizer Fundamentals
  • Generating and Desplaying 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 Managements

Strong knowledge of Oracle Database