Several people asked me how much I changed in the second edition. The short answer is… A LOT.
The main goals set for the revision of the book were the following:
- Add content about Oracle Database 11g Release 2 and Oracle Database 12c Release 1.
- Remove content about Oracle9i and Oracle Database 10g Release 1.
- Add content that was “missing” in the first edition (for example, features like hierarchical profiler, active session history, AWR and Statspack).
- Add information about PHP in the parts that cover features that are specific to programming languages.
- Reorganize part of the material for better readability. For example, splitting the chapter about system and object statistics in two.
- Fix errata and generally enhance the text.
To provide you a visual picture about the changes, with Word I did a diff on the text before and after the editing. Here are the resulting pictures… (note that changes are in red and movements are in green)
- Performance Problems:
- Key Concepts:
- Analysis of Reproducible Problems:
- Real-Time Analysis of Irreproducible Problems: this is a completely new chapter
- Postmortem Analysis of Irreproducible Problems: this is a completely new chapter
- Introducing the Query Optimizer: this is a completely new chapter
- System Statistics:
- Object Statistics:
- Configuring the Query Optimizer:
- Execution Plans:
- SQL Tuning Techniques:
- Parsing:
- Optimizing Data Access:
- Optimizing Joins:
- Beyond Data Access and Join Optimization:
- Optimizing the Physical Design:
Happy reading!
Impressive – bought one @ apress
I enjoyed your first book, and have just bought your second edition from Apress. Looking forward to the post-alpha edition ;)
This 2nd edition (even though alpha version) has still been stunning, and made me learn new things :)
Since I have been one of the Technical Reviewers, I am definitely aware that the second edition contains a wealth of new information, and a lot of big improvements and updates of the “old” material – I have actually really enjoyed reading the book for this very reason. And I experienced first-hand the really hard work that has been necessary to write this book, especially since Chris wanted to keep the quality very high …
It is anyway stunning to see all those changes summarized “in pictures” :O
Your presentation in Paris for Paris Oracle Meetup ( thanks to Gregory ) was very impressive.
I look forward to read the second version of your book ( the first was very interesting ).