Oracle SQL Performance Tuning
Overview
This course introduces the delegate to the main concepts of Oracle SQL performance tuning. It is designed to give delegates practical experience in analyzing and tuning the performance of SQL. This course is suitable for users of Oracle Database 11g and Oracle Database 12c.
Objectives
The delegate will practise:
- Selecting an Appropriate SQL Tuning Approach
- Tuning Database Applications for Optimal Performance
- Managing Statistics
- Creating and Using Indexes
- Structuring SQL Statements for Performance
- Examining and Interpreting the Execution Plan of a SQL Statement using EXPLAIN PLAN
- Examining the Efficiency of SQL Statements using SQL Trace and Autotrace
- Using the SQL Tuning Advisor
- Using SQL Plan Management
- Identifying SQL Statements that Perform Badly
- Managing SQL Performance through Change
- Using Hints to Influence Execution Plan
- Identifying Unused Indexes
Target Audience
The Oracle 12c SQL Performance Tuning course is designed for SQL programmers, application developers, designers and technical support professionals who are required to tune the performance of an Oracle application running under Oracle Database 11g or 12c.
Additional Information
- Course technical content is subject to change without notice.
- Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
A working knowledge of SQL is required. This can be obtained by attendance on the pre-requisite 3 day SQL course.
Additional Learning
The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .
-
Oracle SQL
The SQL training course is designed for anyone who needs to access and work with an Oracle Database
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.