Striving for Optimal Performance
  • Blog
    • Archive
    • Categories
    • Search
  • Troubleshooting Oracle Performance
    • Description
    • Structure
    • Table of Contents
    • Forewords
    • Reviews
    • Downloadable Files
    • Addenda and Errata
    • First Edition
  • Public Appearances
    • Past Public Appearances
  • Contact
  • About

Differences between the First and the Second Edition of Troubleshooting Oracle Performance

5 June 2014 5 Comments Written by Christian Antognini

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)

  1. Performance Problems:
  2. Chapter 1

  3. Key Concepts:
  4. Chapter 2

  5. Analysis of Reproducible Problems:
  6. Chapter 3

  7. Real-Time Analysis of Irreproducible Problems: this is a completely new chapter
  8. Postmortem Analysis of Irreproducible Problems: this is a completely new chapter
  9. Introducing the Query Optimizer: this is a completely new chapter
  10. System Statistics:
  11. Chapter 7

  12. Object Statistics:
  13. Chapter 8

  14. Configuring the Query Optimizer:
  15. Chapter 9

  16. Execution Plans:
  17. Chapter 10

  18. SQL Tuning Techniques:
  19. Chapter 11

  20. Parsing:
  21. Chapter 12

  22. Optimizing Data Access:
  23. Chapter 13

  24. Optimizing Joins:
  25. Chapter 14

  26. Beyond Data Access and Join Optimization:
  27. Chapter 15

  28. Optimizing the Physical Design:
  29. Chapter 16

Happy reading!

TOP
Troubleshooting Oracle Performance, 2nd Edition
RESULT_CACHE Hint in 12.1.0.2

5 Comments

  1. Paul Matuszyk Paul Matuszyk
    5 June 2014    

    Impressive – bought one @ apress

    Reply
  2. Andy Andy
    6 June 2014    

    I enjoyed your first book, and have just bought your second edition from Apress. Looking forward to the post-alpha edition ;)

    Reply
  3. Bundit Bundit
    6 June 2014    

    This 2nd edition (even though alpha version) has still been stunning, and made me learn new things :)

    Reply
  4. Alberto Dell'Era Alberto Dell'Era
    6 June 2014    

    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

    Reply
  5. Stéphane NOTTER Stéphane NOTTER
    9 June 2014    

    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 ).

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.