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