FORGOT YOUR DETAILS?

eluide9eb7f5d

Oracle Database 19c: SQL Tuning Workshop

Cost
$3600 USD
Course Code
D108648GC10
Duration
3 Days
Format
Live Virtual Class

Course Schedule

Oracle Database 19c: SQL Tuning Workshop

$3,600.00

SCHEDULED, 20-Dec-2023 - 22-Dec-2023, 09:00 AM - 05:00 PM US Eastern
SCHEDULED, 15-Apr-2024 - 17-Apr-2024, 09:00 AM - 05:00 PM US Eastern
Choose an option
Oracle Database 19c: SQL Tuning Workshop – SCHEDULED, 20-Dec-2023 - 22-Dec-2023, 09:00 AM - 05:00 PM US Eastern
$3,600.00
Oracle Database 19c: SQL Tuning Workshop – SCHEDULED, 15-Apr-2024 - 17-Apr-2024, 09:00 AM - 05:00 PM US Eastern
$3,600.00
SKU: D108648GC10 Categories: , ,

Overview

the Oracle database. Students learn to interpret execution plans and the different ways in which data can be accessed. Students are shown how to decipher, decide and then apply tuning to their SQL code. Various tuning techniques are demonstrated. For example, taking advantage of bind variables, trace files, and using the different types of indexes.

Learn To:

  • Use Oracle tools to identify inefficient SQL statements.
  • Write more efficient SQL statements.
  • Monitor and trace high load SQL statements.
  • Manage optimizer statistics on database objects.
  • Understand the optimizer process steps and operators.
  • Interpret execution plans.
  • Perform application tracing.

Audience

  • Database Administrators
  • Developers

Suggested Prerequisites

Oracle Database 19c: SQL Workshop

Topics

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

Overview

the Oracle database. Students learn to interpret execution plans and the different ways in which data can be accessed. Students are shown how to decipher, decide and then apply tuning to their SQL code. Various tuning techniques are demonstrated. For example, taking advantage of bind variables, trace files, and using the different types of indexes.

Learn To:

  • Use Oracle tools to identify inefficient SQL statements.
  • Write more efficient SQL statements.
  • Monitor and trace high load SQL statements.
  • Manage optimizer statistics on database objects.
  • Understand the optimizer process steps and operators.
  • Interpret execution plans.
  • Perform application tracing.

Audience

  • Database Administrators
  • Developers

Suggested Prerequisites

Oracle Database 19c: SQL Workshop

Topics

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

Related Courses…

TOP
0