back to Course Categories | back | print
Oracle10g SQL Tuning for DBAs          

Duration: 3 days

Description 
This class is designed to teach Oracle DBAs SQL tuning techniques and best practices. DBAs will learn how to leverage key SQL tuning information stored in the Oracle data dictionary. All the SQL tuning tools available in the Oracle database server and Database Control will be covered. DBAs will learn the details of the Cost Based Optimizer (CBO). DBAs will learn how to customize the CBO for OLTP and DSS environments. DBAs will learn the pros and cons of using SQL tuning tools such as explain plans, SQL Trace, Statspack, ADDM, AWR, the SQL Tuning Advisor and the SQL Access Advisor.

Topics

  • Developing a SQL tuning methodology
  • Internal performance metrics
  • Fundamentals of SQL tuning
  • Understanding the cost-based optimizer
  • CBO internals
  • SQL tuning for OLTP
  • SQL tuning for DSS
  • SQL tuning best practices.
  • Top SQL and ADDM
  • Using AWR for SQL tuning
  • SQL tuning advisor
  • SQL access advisor
  • SQL tuning sets
  • SQL profiles
  • SQL tuning statistics in DBMS_STATS
  • Understanding explain plans
  • Access methods
  • Table access methods
  • Index unique scan
  • Index range scan
  • Index skip scan
  • Index fast full scan
  • Index full scan
  • Index joins
  • Bitmap join indexing
  • Evaluating execution plans
  • Autotrace
  • SQL Trace
  • Oracle 10046
  • 10053 trace data
  • Statspack
  • Tkprof
  • Evaluating runtime statistics
  • Evaluating complex execution plans
  • Join optimization methods
  • Nested loops join
  • Hash join
  • Sort merge join
  • Merge join cartesian
  • Tuning joins and subqueries
  • Tuning using hints
  • Tuning for different types of tables
  • Tuning for indexes
  • Composite key order
  • Histograms
  • IN vs. EXISTS
  • NOT IN vs. NOT EXISTS
  • CASE
  • Session tuning
  • SQL tuning for partitioning
  • Parallel query tuning
  • Tuning data warehouse environments

Prerequisites

  • Previous Oracle database administration experience.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design