A Guide To The Performance Tuning Enhancents In Oracle 10g
There's a good article currently running over at Oracle-base.com detailing the performance tuning enhancements in Oracle Database 10g. It's a fairly detailed document and covers the following areas;
- Automatic Performance Diagnostic and Tuning Features
 - Automatic Shared Memory Management
 - Wait Model Improvements
 - Automatic Optimizer Statistics Collection
 - Dynamic Sampling
 - CPU Costing
 - Optimizer Hints
 - Rule Based Optimizer Obsolescence
 - Tracing Enhancements
 - SAMPLE Clause Enhancements
 - Hash Partitioned Global Indexes