Oracle9i Performance Tuning: Optimizing Database Productivity / Edition 1 available in Paperback
- Pub. Date:
- Cengage Learning
This text provides Database Administrators, Database Designers, and Developers with the necessary resources to be proactive in preventing performance problems. This book fully prepares students for the Oracle9i Database Performance Tuning exam (#1Z0-033) under the Oracle9i Certified Professional Database Administrator (DBA) track.
|Edition description:||New Edition|
|Product dimensions:||7.40(w) x 9.20(h) x 1.50(d)|
About the Author
Hassan A. Afyouni has been working in the information technology field as a consultant for over fifteen years as database developer, database architect, database administrator, and data architect. He has been an instructor at several universities in Canada and the US, a corporate trainer for some major corporations, and a curriculum developer for various courses and programs.
Table of Contents
Part 1: 1. Performance Tuning Overview Part 2: 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: 6. Optimizing Data Storage 7. Optimizing Tablespaces 8. Tuning Undo Segments Part 4: 9. Detecting Lock Contention 10. Other Tuning Issues 11. Advanced Tuning Topics Part 5: 12. Tuning Tools Part 6: 13. SQL Tuning 14. Optimizing Applications 15. Tuning Workshop and Statistic Collector Project Appendix A: Oracle Architecture Overview Appendix B: Diagnostic Queries Collection