A Guide To The Performance Tuning Enhancents In Oracle 10g
May 20th, 2004 by Mark Rittman
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
