Overview of Oracle9i Performance Tuning
- Scalability is a major factor to be considered in performance and tuning
- Data dictionary information is held in the memory for a long time than the library cache data. Good hit ratio rate in library cache imply acceptable hit ratios in the dictionary cache. Data dictionary cache misses are more expensive than library cache misses.