• Oracle Database 11g: SQL Tuning Workshop (11g-TUNI
  Oracle Database 11g: SQL Tuning Workshop (11g-TUNING-WRK)培訓
  培訓大綱：
  1. Exploring the Oracle Database Architecture
  Oracle Database Server Architecture
  Oracle Database Memory Structures
  Background Process Roles
  Automatic Shared Memory Management
  Automated SQL Execution Memory Management
  Automatic Memory Management
  Database Storage Architecture
  Logical and Physical Database Structures
  2. Introduction to SQL Tuning
  Reasons for Inefficient SQL Performance
  Performance Monitoring Solutions
  Monitoring and Tuning Tools
  EM Performance Pages for Reactive Tuning
  CPU and Wait Time Tuning Dimensions
  Scalability with Application Design, Implementation, and Configuration
  Common Mistakes on Customer Systems
  Proactive Tuning Methodology
  3. Introduction to the Optimizer
  Structured Query Language
  SQL Statement Representation and Implementation Processing
  SQL Statement Parsing
  Why Do You Need an Optimizer?
  Optimization During Hard Parse Operation
  Cost-Based Optimizer
  Controlling the Behavior of the Optimizer
  Optimizer Features and Oracle Database Releases
  4. Optimizer Operators
  Row Source Operations
  Main Structures and Access Paths
  Full Table Scan
  Indexes
  Using Indexes: Considering Nullable Columns
  Bitmap Indexes, Composite Indexes, and Invisible Index
  Guidelines for Managing Indexes
  Clusters
  5. Interpreting Execution Plans
  Execution Plan
  Links Between Important Dynamic Performance Views
  Automatic Workload Repository (AWR)
  Generating SQL Reports from AWR Data
  SQL Monitoring
  Reading More Complex Execution Plans
  Reviewing the Execution Plan
  Looking Beyond Execution Plans
  6. Case Study: Star Transformation
  The Star Snowflake Schema Model
  Execution Plan Without Star Transformation
  Retrieving Fact Rows from One Dimension and All Dimensions
  Joining the Intermediate Result Set with Dimensions
  Using Bitmap and Join Indexes
  Star Transformation
  Bitmap and Join Indexes
  7. Optimizer Statistics
  Types of Optimizer Statistics
  Multicolumn Statistics
  Expression Statistics
  Gathering System Statistics
  Statistic Preferences
  Optimizer Dynamic Sampling
  Locking Statistics
  8. Using Bind Variables
  Cursor Sharing and Different Literal Values
  Cursor Sharing and Bind Variables
  Bind Variables in SQL*Plus Enterprise Manager
  Cursor Sharing Enhancements
  Adaptive Cursor Sharing
  Interacting with Adaptive Cursor Sharing
  9. Using Optimizer Hints
  Optimizer Hints
  Types of Hints
  Specifying Hints
  Rules for Hints
  Hint Recommendations
  Hint Categories
  Optimization Goals and Approaches
  Additional Hints
  10. Application Tracing
  End-to-End Application Tracing Challenge
  Location for Diagnostic Traces
  What is a Service?
  Use Services with Client Applications
  Trace Your Own Session
  SQL Trace File Contents
  Formatting SQL Trace Files
  Invoking the tkprof Utility
  11. Automating SQL Tuning
  Tuning SQL Statements Automatically
  Application Tuning Challenges
  SQL Tuning Advisor
  Stale or Missing Object Statistics
  SQL Statement Profiling
  Plan Tuning Flow and SQL Profile Creation
  Database Control and SQL Tuning Advisor
  Implementing Recommendations
  ?
• 
  ?
• 
  ?
• 
  ?
  ?
  ?
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?