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 for Developers and DBA's
 
 
Duration 3 Days
Delivery Method Instructor Led, Hands-on Workshops
Public Price $1800.00


DESCRIPTION (Return to Top)

This course provides students with a thorough, behind the scenes look at Oracle application tuning. 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 understand the importance of object 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, other SGA structures, indexes 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.



AUDIENCE (Return to Top)

Oracle Developers and Oracle Database Administrators (DBAs).



TOPICS (Return to Top)
  • Database Tuning Overview
  • Understanding the Database Architecture
  • Automatic Shared Memory Management (ASMM & AMM)
  • SQL – Behind the Scenes
  • SQL and its Data
  • Tuning Sorts and Temporary Work Space
  • Tuning Inserts, Updates and Deletes
  • Understanding the Oracle Optimizer
  • Using EXPLAIN PLAN and AUTOTRACE
  • SQL Performance Tips and Techniques


PREREQUISITES (Return to Top)

OR5450 Oracle SQL or equivalent experience.