|
Art & Science of Oracle Performace Tuning - Reprint
Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding
the technology. It is more than tweaking parameters or following a set prescription--it involves matching application-specific knowledge with what's happening inside the database.
Based on author Christopher Lawson's long experience working with Oracle, The Art and Science of Oracle Performance Tuning book uses a five-step model to help identify and isolate the cause of nonperformance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success.
Chapter 1: The Challenge of Performance Tuning
Chapter 2: Why Many Tuning Strategies Fail
Chapter 3: The Oracle Physician
Chapter 4: Dealing with Humans
Chapter 5: The Oracle Detective
Chapter 6: Gathering More Clues
Chapter 7: The Oracle Pathologist
Chapter 8: Analyzing SQL Bottlenecks
Chapter 9: Anazlyzing SQL Joins
Chapter 10: The Pathologist's Toolkit: Other Tactics
Chapter 11: The Oracle Artist
Chapter 12: The Artist's Palette: More on Devising Solutions
Chapter 13: The Oracle Magician
Chapter 14: Case Studies
Appendix A: Useful V$ View Definitions
|
