Oracle Database 19c: SQL Tuning Workshop

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