|
Oracle 9i Performance Tuning: Optimizing Database Productivity
This text provides Database Administrators, Database Designers, and Developers with the necessary resources to be proactive in preventing performance problems. It contains detailed discussions on how to tune the database from every aspect. By presenting information about how to optimize queries, tune database memory, storage allocation, I/O contention
and resource contention, this text elaborates on all Oracle performance tools available. This book will prepare students for the Oracle9i Database Performance Tuning exam (#1Z0-033) under the Oracle9i Certified Professional Database Administrator (DBA) track.
Contents:
Part 1: Tuning Fundamentals
1. Performance Tuning Overview
Part 2: Tuning Memory
2. Tuning the Buffer Cache
3. Tuning the Redo Log Buffer
4. Tuning the Shared Pool Memory
5. Working with the Program Global Area
Part 3: Tuning Storage
6. Optimizing Data Storage
7. Optimizing Tablespaces
8. Tuning Undo Segments
Part 4: Advanced Tuning
9. Detecting Lock Contention
10. Other Tuning Issues
11. Advanced Tuning Topics
Part 5: Tools
12. Tuning Tools
Part 6: Application Tuning
13. SQL Tuning
14. Optimizing Applications
15. Tuning Workshop and Statistic Collector Project
|
