Member of the highly respected

Five Days Hands-on Performance Tuning Course Agenda

1.What is optimization?
   1.Possible approaches
   2.How we can diagnose the real bottlenecks?
   3.What are the goals of the optimization project?
   4.What are the prerequisites for successful
     optimization?
2.Database Architecture
   1.SGA
   2.PGA
   3.Undo/Redo
   4.Memory management and optimization
3.SQL statement processing
   1.SQL Area
   2.SQL statement execution
  §Parse phase
  §Execute phase
  §Fetch phase
   3.Parallel execution
   4.Resource consumption monitoring
   5.Optimization of memory usage of shared pool
   6.Execution plan
   7.Interpretation of execution plan.
4.How the optimizer works?
   1.Rule Based Optimizer (RBO)
   2.Cost Based Optimizer (CBO)
   3.Statistics and Histograms

5.Preparation of trace files
    1.event 10053
    2.event 10046
    3.Necessary setup steps
6.All about wait events
7.Access Path Optimization
8.All about indexes
    1.When an index is selective?
    2.When an index should not be used?
    3.Is my index ever used?
    4.How CBO calculate the cost of index access?
    5.Bitmap indexes
    6.Function-based indexes
9.All about optimizer hints
10.Optimization of physical layer
    1.I/O problems
    2.Table and index partitioning
    3.SAME methodology
11.New features in SQL language in 9i and 10g
12.New features of Oracle 9i and 10g important for
    developers
13.Sorting
14.Materialized views
15.Temporary tables
16.Index organized tables
17.SQL statement execution plan stability
18.Advanced Diagnostics