back to Course Categories | back | print
Oracle10g: Advanced Oracle Tuning Workshop for Developers          

Duration: 3 days

Description 
This class is designed to teach Oracle developers advanced Oracle tuning skills. This class will teach developers Oracle optmization techniques so developers will understand how to write optimized applications that leverage Oracle features. Attendees will learn the Oracle architecture and how an Oracle database server needs to be configured for different types of applications. This class will teach developers all the information DBAs know related to application optimization. Topics will also include how to write code using large multi-way joins, deep nested queries against complex data structures. Attendees will evaluate execution plans using large joins, partitioned tables, index-organized tables and complex indexes. Code will be written using advanced analytics, advanced functions, external tables, table functions, predictive analysis and using new model features in Oracle10g. The goal of this class is to teach attendees advanced SQL skills that need to be used in today's complex Oracle environments. Data warehousing optimization will be include. This class will be taught in a hands-on workshop versus the traditional lecture/labs environment.

Topics

  • The Oracle architecture
  • Oracle optimization for applications
  • Understanding Oracle processing
  • Tuning the database server for performance
  • Internal performance metrics
  • Tuning methodologies
  • Fundamentals of SQL tuning
  • Understanding the cost-based optimizer
  • CBO internals
  • SQL tuning best practices.
  • Top SQL and ADDM
  • SQL tuning advisor
  • SQL tuning sets
  • SQL profiles
  • Generating statistics using DBMS_STATS
  • ANALYZE versus 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
  • Tuning data warehouse environments

Prerequisites

  • A fundamental understanding of SQL and Oracle development environments.


 
 
 

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