Cover image for The art and science of Oracle performance tuning
The art and science of Oracle performance tuning
Lawson, Christopher.
Personal Author:
Publication Information:
[Berkeley, CA] : Apress ; New York : Distributed to the book trade in US by Springer-Verlag, [2004]

Physical Description:
xi, 459 pages : illustrations ; 23 cm
General Note:
Includes index.
Title Subject:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 L383 2004 Adult Non-Fiction Non-Fiction Area

On Order



* Presents an innovative, philosophical approach to Oracle database administration, and shows how to think about the whole complex problem of performance tuning, how to break it down, how to root out the cause of performance bottlenecks.

*Covers all practical aspects of Oracle performance tuning.

* Filled with hands-on lessons and accounts.

* Teaches an innovative and effective "Physician to Magician" approach, showing how to understand the problem, uncover the root cause, and choose and implement the most effective solution.

Author Notes

Christopher Lawson is an independent consultant who specializes in performance tuning of data warehouse and financial applications. His articles on database management and performance tuning have appeared in numerous technical journals, and he is a frequent speaker at Oracle conferences. When he isn't tracking down elusive performance problems, Chris teaches courses on enterprise database systems for the University of Phoenix. He is also editor of the online magazine The Oracle Magician, available at Chris earned his bachelor's degree and master's in business administration at the University of California, Irvine.

Table of Contents

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