Oracle 12c Application Tuning Training
Introduction
This course is designed for Designers, Developers, and Database Administrators, and examines all aspects of tuning SQL statements and applications.
Prerequisites
A sound knowledge of SQL and PL/SQL is required.
Duration
3 days
Agenda
- Defining a Tuning Methodology
- Diagnostic Tools
- Processing an SQL Statement
- Indexes
- Cost Based Optimisation
- Gathering Statistics
- Tracing and SQLTXPLAIN
- Adaptive Optimisation
- Data Warehouse and Large Database Design
- SQL Profiles
- Storage Parameters
- Hash Clusters and Index Clusters
- Optimising PL/SQL
- Optimising Applications through Stored Procedures and Packages
- Using the Results Cache
- Data Design for Performance
- Tuning Tips
- Partitions
- Optimise using Parallelisation
- Tuning Tools
Who are our trainers?
Oracle ACE Alumni Penny Cookson and Oracle ACE
Scott Wesley
head our team of experienced consultants and trainers.
Penny was recognised as Oracle Educator of the Year in 2004
Complete Agenda
Download the complete Course Catalog (450kb)
Interested in booking training?
to enquire about our courses
Back to Training