Oracle10g Tuning para Desarrolladores

CONTENIDOS

• Following a Tuning Methodology
• Describing the Causes of Performance Problems
• Identifying Performance Problems
• Using a Tuning Methodology
• Designing Applications for performance
• Oracle Methodology
• Understanding Scalability
• System Architecture
• Application Design Principles
• Deploying New Applications
• Introducing the optimizer
• Describe the functions of the Oracle optimizer
• Identify the factors that the optimizer considers when it selects an execution plan
• Set the optimizer approach at the instance and session level
• Use dynamic sampling
• Optimizer Operations
• Execution plans
• Types of Joins
• Displaying Execution plans
• Using the EXPLAIN PLAN Command
• Interpreting EXPLAIN Output
• Interpreting AUTOTRACE Statistics
• Gathering Statistics
• Using the DBMS_STATS Package
• Identifying Table, Column, and Index Statistics
• Building Histograms
• Application Tracing
• Statspack
• End to End tracing
• Invoking the SQL Trace Facility
• Setting Up Appropriate Initialization Parameters
• Formatting Trace Files with TKPROF
• Interpreting the Output of the TKPROF Command
• Identifying High Load SQL
• Use different methods to identify high-load SQL
• ADDM
• Top SQL
• Dynamic Performance views
• Statspack
• Automatic SQL Tuning
• Query Optimizer Modes
• Types of Tuning Analysis
• SQL Tuning Advisor
• SQL Tuning Sets
• Top SQL
• Introduction to Indexes
• Identifying Row Access Methods
• Creating B-Tree Indexes
• Understanding B-Tree Index Access and Index Merging
• Advanced Indexes
• Using Bitmapped Indexes
• Using Function-Based Key Indexes
• Optimizer Hints and Plan Stability
• Using Hints
• Purpose and Benefits of Optimizer Plan Stability
• Materialized Views and Temporary Tables
• Using the CREATE MATERIALIZED VIEW Syntax
• Utilizing Query Rewrites