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

Troubleshooting Oracle Performance, 2nd Edition

by Christian Antognini

Troubleshooting Oracle Performance, 2nd Edition

Pages: 740
Publisher: Apress
Publishing date: 5 June 2014
Language: English
ISBN-13 (softcover): 978-1-4302-5758-5
ISBN-13 (electronic): 978-1-4302-5759-2

Here you’ll find detailed information about the book, including:

  • Description
  • Structure
  • Table of Contents
  • Forewords by Jonathan Lewis and Cary Millsap
  • Reviews (last update: 2017-07-26)
  • Downloadable Files (last update: 2018-08-17)
  • Addenda and Errata (last update: 2020-05-06)

You can order the book from Apress or from one of the Amazon sites, e.g. DE FR IN UK US.

At apress.com it is also available as an ebook (formats: EPUB, MOBI, PDF). Amazon also provides a Kindle Edition. Online versions are available on Safari and Google Books.

Troubleshooting Oracle Performance, 2nd Edition (Korean)

A Korean edition, published in May 2016 by J-Pub, is also available.

You can send any type of questions or feedback about the book at top@antognini.ch. If you want, you can also use the contact form.

19 Comments

7 Pings/Trackbacks

  1. andjelko Miovcic andjelko Miovcic
    24 October 2014    

    I would say this book is one of the best oracle performance tuning books.

    Thanks,
    Andjelko Miovcic

    Reply
  2. jean-michel jean-michel
    2 December 2014    

    Hi Christian,

    I have just bought TOP 2nd edition on Apress ( ebook format ).
    For me, it is a must !

    Thank you for the way you share your knowledge of Oracle with the community.

    Greetings from France

    Jean-michel A.

    Reply
  3. Santosh Gaikwad Santosh Gaikwad
    14 January 2015    

    I have never seen such a wonderful book before ever on oracle performance tuning. The examples are very useful and the holiastic approach to explain everything with the help of examples is AWESOME. The design and step by step approach is so intuative that i felt like the author is in front me explaining things. Kudos to this writing. Thanks!

    Reply
  4. Sandeep Sandeep
    22 March 2015    

    I am impressed, the way SQL Tracing is explained with examples, yet to cover the rest of the book.

    Reply
  5. Book Review: Oracle SQL Tricks and Workarounds | recurrent null Book Review: Oracle SQL Tricks and Workarounds | recurrent null
    19 April 2015    

    […] knowledge is key, and for that, I totally recommend studying another book: Chris Antognini’s Troubleshooting Oracle Performance. Most readers will surely know the book, so I won’t add much more here, apart from it […]

  6. Mark Hughes Mark Hughes
    10 May 2015    

    This is the best and most complete book I have ever found on Oracle performance tuning.
    many thanks,
    Mark Hughes

    Reply
  7. Deepak Deepak
    18 May 2015    

    This is one of best books about oracle performance tuning. Well structured and all the useful information regarding performance tuning is available here.

    Reply
  8. SQL Tuning: Thinking in Sets / How and When to be Bushy | OraStory SQL Tuning: Thinking in Sets / How and When to be Bushy | OraStory
    5 November 2015    

    […] http://www.oaktable.net/content/right-deep-left-deep-and-bushy-joins https://tonyhasler.wordpress.com/2008/12/27/bushy-joins/ https://antognini.ch/top/ […]

  9. What to do if a database performance issue is reported | Andrew Fraser DBA What to do if a database performance issue is reported | Andrew Fraser DBA
    14 December 2015    

    […] Antognini, Troubleshooting Oracle Performance 2nd Edition, buy from https://antognini.ch/top/ or free download from university […]

  10. Vladmir Vladmir
    18 June 2016    

    Grateful to you forever for sharing your knowledge and experience! The most useful book.

    Reply
  11. Slim Slim
    17 August 2016    

    Short and precise, excellent book , thanks !

    Reply
  12. Avoid mistakes when Gathering System StatsRainer Hartwig – Oracle und Linux | Rainer Hartwig – Oracle und Linux Avoid mistakes when Gathering System StatsRainer Hartwig – Oracle und Linux | Rainer Hartwig – Oracle und Linux
    15 October 2017    

    […] Antognini descibed in his book Troubleshooting Oracle Performance how to gather the system statistics in a very proficient way. The main idea of gathering system […]

  13. Oracle Partitioning: 4^ parte, creazione tabelle partizionate – Oracle and other Oracle Partitioning: 4^ parte, creazione tabelle partizionate – Oracle and other
    10 January 2019    

    […] per ora non ne scrivo. Riporto solo una piccola annotazione:  Christian Antognini, nel suo libro dopo aver descritto nel dettaglio i vari “percorsi” di accesso che può utilizzare […]

  14. Materialized View Refresh for Dummies | Data Warehousing with Oracle Materialized View Refresh for Dummies | Data Warehousing with Oracle
    18 February 2019    

    […] examples of how to use and refresh them, you can find these descriptions in chapter 15 of the book Troubleshooting Oracle Performance, 2nd Edtition of my Trivadis colleague Christian […]

  15. Giuseppe Giuseppe
    19 November 2019    

    What about third edition?
    I sincerely hope that you are working on it. :-D
    Great work.

    Reply
    • Christian Antognini Christian Antognini
      19 November 2019    

      Ciao Giuseppe

      Yes, I’m working on it. Not sure when it’ll be ready, though.

      Chris

      Reply
  16. Giuseppe Difalco Giuseppe Difalco
    19 August 2022    

    Hi Christian.
    Any news about TOP3?
    All performance oriented DBAs are waiting it.

    Regards

    Reply
    • Christian Antognini Christian Antognini
      31 October 2022    

      Hi Giuseppe
      First of all, sorry for the very late reply.
      I have no deadline (publishing date). But given that next year Oracle will ship the next long-term release, it would be wise to cover it in TOP3…
      Best,
      Chris

      Reply
  17. optimizer_secure_view_merging and plsql_declarations - Philipp Salvisberg's Blog optimizer_secure_view_merging and plsql_declarations - Philipp Salvisberg's Blog
    30 October 2022    

    […] explains optimizer_secure_view_merging on page 289 to 291 in Troubleshooting Oracle Performance, 2nd Edition. On page 291 he writes the […]

  1. Book Review: Oracle SQL Tricks and Workarounds | recurrent null on 19 April 2015 at 18:05
  2. SQL Tuning: Thinking in Sets / How and When to be Bushy | OraStory on 5 November 2015 at 17:48
  3. What to do if a database performance issue is reported | Andrew Fraser DBA on 14 December 2015 at 22:05
  4. Avoid mistakes when Gathering System StatsRainer Hartwig – Oracle und Linux | Rainer Hartwig – Oracle und Linux on 15 October 2017 at 23:09
  5. Oracle Partitioning: 4^ parte, creazione tabelle partizionate – Oracle and other on 10 January 2019 at 13:00
  6. Materialized View Refresh for Dummies | Data Warehousing with Oracle on 18 February 2019 at 20:19
  7. optimizer_secure_view_merging and plsql_declarations - Philipp Salvisberg's Blog on 30 October 2022 at 11:57

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.