Oracle9i Performance Tuning
Optimizing Database Productivity
Published on 27. February 2004
Book
Paperback/Softback
982 pages
978-0-619-16004-3 (ISBN)
Description
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.
More details
Language
English
Place of publication
Boston, MA
United States
Publishing group
Cengage Learning, Inc
Target group
Professional and scholarly
College/higher education
Illustrations
Illustrations
Dimensions
Height: 234 mm
Width: 188 mm
Thickness: 33 mm
Weight
1521 gr
ISBN-13
978-0-619-16004-3 (9780619160043)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
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