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

TOP Is At Last Available

7 July 2008 7 Comments Written by Christian Antognini

Troubleshooting Oracle Performance

At last my book, Troubleshooting Oracle Performance (TOP), is available! The proof is that today I have received my first printed copies.

What a special moment!

You will find more information about the book, links to online bookstores and more at http://top.antognini.ch.

The publishing date had been postponed several times. For that, I would like to apologize to all the people that had pre-ordered it loooooong time ago. Anyway, now it is available for anyone who wants it.

Hope you enjoy it!

TOP
Operation CONNECT BY WITH FILTERING
Ad: Tanel Poder's Seminars in Europe

7 Comments

  1. Aman.... Aman....
    8 July 2008    

    Congrats Chris,its been ordered now and hopefully in one week,it should be in my hands.
    Looking forward to add one more great resource in my stock.And also going to trouble you alot with lots of questions ;-).
    Regards
    Aman….

    Reply
  2. Marco Gralike Marco Gralike
    12 July 2008    

    Looking forware to it ;-)
    I will ask to order two for our AMIS library.
    Knowing you, it can only be interesting performance “food”

    Reply
  3. Peter K Peter K
    14 July 2008    

    Congratulations! Looking forward to getting a copy.

    Reply
  4. Hans Forbrich Hans Forbrich
    25 July 2008    

    Congratulations. I returned from a business trip last night, and my copy had arrived. Already skimmed once, this book is designated for the ‘important reference works’ bookshelf.

    Once I have read it (several times – there is a lot in there) it will find it’s home is right next to Tom Kyte’s, Cary Millsap’s and Jonathan Lewis’ books where I immediately access it.

    Reply
  5. Michael Finocchiaro Michael Finocchiaro
    27 July 2008    

    Excellent book!! I have been reading it since I got it last week. I totally agree with Hans’ comment about it being up there with Kyte, Lewis and Millsap…that being said, where is part 2 of the CBO stuff Jonathan??
    Anyway, one thing I was confused about: on page 13 you say “The selectivity is a value between 0 and 1 representing the fraction of rows returned by an operation”. However, on page 30, you show an example where the calculated selectivity is 1.088989. Did I miss something because 1.09 is higher than 1 right?
    I was also a bit confused about the difference between parent and child cursors in the related discussion in chapter 2. Is the parent the original SQL text from the query and the child is the resulting explain plan? It didn’t seem to be clearly stated in the text, but then I may have missed it.
    I have recommended this book to all of my colleagues already. Thanks soooo much!

    Reply
  6. Christian Antognini Christian Antognini
    27 July 2008    

    Hi Michael

    > where is part 2 of the CBO stuff Jonathan??

    AFAIK Jonathan is working on it. But for more information you should ask Jonathan…

    > Did I miss something because 1.09 is higher than 1 right?

    Honestly, I have no idea why Oracle does that. Also in my opinion it makes no sense.

    > Is the parent the original SQL text from the query
    > and the child is the resulting explain plan?

    Simply put it is correct to say that the parent is the SQL text and the child the execution plan. Of course, both the parent and the child contains much more information.

    Cheers,
    Chris

    Reply
  7. Doug Burns Doug Burns
    28 August 2008    

    My copy turned up yesterday and, based on an initial glance, I wish it was nearer the top of my list of books to read ;-) (Then again, those flights to San Francisco are very long!)

    Oh, and even if you never thought you would have a blog, Chris, I’m glad you do.

    Cheers, Doug

    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.