back to Course Categories | back | print
Oracle9iR2: SQL and PL/SQLTuning          

Duration: 3 days

Description 
This is an in-depth and complete class in tuning SQL and PL/SQL applications in Oracle9i. This tuning class takes a comprehensive look at tuning Oracle9i applications. To tune applications properly developers need to understand how Oracle works, how Oracle processes their code, how to tune the Oracle runtime environment, how to get the cost-based optimizer to make the best decisions, and how to use Oracle tuning tools to tune SQL and PL/SQL applications. This class uses simple and complex (very large) schemas to give developers practice in tuning for different types and sizes of tables.

Topics

  • Developing a tuning methodology
  • The Oracle9i architecture for developers
  • Fundamentals of SQL tuning in an Oracle environment
  • Rule versus (RBO) cost-based optimzer (CBO)
  • Understanding the decisions the CBO makes
  • Tuning the Oracle9i runtime environment for different applications
  • Generating statistics using DBMS_STATS
  • Generating statistics using ANALYZE command
  • Explain plan
  • Evaluating execution plans
  • Autotrace
  • SQL Trace
  • Tkprof
  • Evaluating runtime statistics
  • Join optimization methods
  • Tuning joins and subqueries
  • Tuning using hints
  • Tuning for different types of tables
  • Tuning for indexes
  • Session tuning
  • Tuning PL/SQL code
  • Optimizing dynamic SQL
  • Optimizing bulk operations and bulk collects
  • DBMS_TRACE
  • DBMS_DEBUG
  • DBMS_PROFILER
  • Data warehousing features

Prerequisites

  • A solid understanding of SQL and PL/SQL programming.

  • This course focuses on SQL and PL/SQL tuning. The Oracle9i SQL Tuning class focuses on just SQL tuning concepts.

 
 
 

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