Virtual Instructor-Led Training
3 Days (24 Hours)Optimize SQL performance in Oracle 12c by learning tuning techniques and improving query efficiency for better database operations.
Course Objectives
- Modifying a SQL statement to perform at its best
- Identifying poorly performing SQL
- Tracing an application through its different levels of the application architecture
- Understanding how the Query Optimizer makes decisions about how to access data
- Defining how optimizer statistics affect the performance of SQL
Upcoming Schedules
Course Prerequisites
Required
- Familiarity with database architecture
- Knowledge of SQL and PL/SQL
Course Outline
Introduction
- Course Objectives, Course Agenda and Appendixes Used in this Course
- Audience and Prerequisites
- Sample Schemas Used in the Course
- Class Account Information
- SQL Environments Available in the Course
- Workshops, Demo Scripts, and Code Example Scripts
- Appendices in the Course
Introduction to SQL Tuning
Using Application Tracing Tools
Understanding Basic Tuning Techniques
Optimizer Fundamentals
Generating and Displaying Execution Plans
Interpreting Execution Plans and Enhancements
Optimizer Join Operations
Other Optimizer Operators
Introduction to Optimizer Statistics Concepts
Using Bind Variables
SQL Plan Management
Workshops