Cargando…

Oracle performance tuning for 10gR2 /

Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improve...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Powell, Gavin
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Burlington, MA : Digital Press, �2007.
Edición:2nd ed.
Temas:
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Preface
  • Introduction
  • Part I. Data Model Tuning
  • Chapter 1. The Relational Database Model
  • Chapter 2. Tuning the Relational Database Model
  • Chapter 3. Different Forms of the Relational Database Model
  • Chapter 4. A Brief History of Data Modeling
  • Part II. SQL Code Tuning
  • Chapter 5. What is SQL?
  • Chapter 6. Basic Concepts of Efficient SQL
  • Chapter 7. Advanced Concepts of Efficient SQL
  • Chapter 8. Common Sense Indexing
  • Chapter 9. Oracle SQL Optimization and Statistics
  • Chapter 10. How Oracle SQL Optimization Works
  • Chapter 11. Overriding Optimizer Behavior Using Hints
  • Chapter 12. How to Find Problem Queries
  • Chapter 13. Automated SQL Tuning
  • Part III. Physical and Configuration Tuning
  • Chapter 14. Installing Oracle and Creating a Database
  • Chapter 15. Tuning Oracle Database File Structures
  • Chapter 16. Object Tuning
  • Chapter 17. Low Level Physical Tuning
  • Chapter 18. Hardware Resource Usage Tuning
  • Chapter 19. Tuning Network Usage
  • Chapter 20. Oracle Partitioning and Parallelism
  • Chapter 21. Ratios: Possible Symptoms of Problems
  • Chapter 22. Wait Events
  • Chapter 23. Latches
  • Chapter 24. Tools and Utilities
  • Part IV. Tuning Everything at Once
  • Chapter 25. The Wait Event Interface
  • Chapter 26. The Database Control
  • Chapter 27. Tuning With STATSPACK
  • Appendices
  • Appendix A. Sample Databases
  • Appendix B. Sample Scripts (script changes)
  • Appendix C. Sources of Information (accreditations)Appendix D. SQL Tuning in Oracle Enterprise Manager
  • (might delete this one, depending on how much I remove from part III, which is 9i).
  • pt. 1. Data model turning
  • The relational database model
  • Turning the relational database model
  • Different forms of the relational database model
  • A brief history of data modeling
  • pt. 2 SQL code tuning
  • What is SQL?
  • The basics of efficient SQL
  • Advanced concepts of efficient SQL
  • Common-sense indexing
  • Oracle SQL optimization and statistics
  • How Oracle SQL optimization works
  • Overriding optimizer behavior using hints
  • How to find problem queries
  • 10g automated SQL tuning
  • pt. 3. Physical and configuration tuning
  • Tuning Oracle database file structures
  • Object tuning
  • Low-level physical tuning
  • Hardware resource usage tuning
  • Tuning network usage
  • Oracle partitioning and parallelism
  • pt. 4. Tuning everything at once
  • Ratios: possible symptoms of problems
  • Wait events
  • Latches
  • Tools and utilities
  • The wait event interface
  • 9i tuning with STATSPACK.