On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:


Search for Course:

OR5480 Oracle SQL Optimization
 
 
Duration 3 Days
Delivery Method Instructor Led, Hands-on Workshops
Public Price $1625.00


DESCRIPTION (Return to Top)

This course provides students with an introduction to application and database tuning. Students will learn how the cost-based optimizer works. A discussion of basic Oracle architecture will provide the foundation for understanding both SQL statement and system performance. Students will use EXPLAIN PLAN and AUTOTRACE for evaluating execution strategies and the DBMS_STATS package for gathering optimizer statistics. Also discussed is how to influence the behavior of the optimizer with hints, physical schema changes, and alternative SQL statement syntax. Factors that affect overall system performance such as the buffer cache, SGA structures, and waits due to locks and latches are presented.

Hands-on workshops provide students with a solid understanding of the concepts presented in the lectures.

This course can be taught for any Oracle version.



AUDIENCE (Return to Top)

Database administrators and application designers and developers.



TOPICS (Return to Top)
  • Tuning Overview
  • Oracle Architecture
  • ALERT Logs, Trace Files, and Events
  • SQL Statement Processing
  • SQL Statement Tuning
  • Indexes
  • Cost-Based Optimizer
  • Influencing the Optimizer
  • Tuning Tools
  • SQL Plan Management
  • Locking and Concurrency


PREREQUISITES (Return to Top)

OR5450 Oracle SQL or equivalent experience.