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!
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 ;-).
Looking forware to it ;-)
I will ask to order two for our AMIS library.
Knowing you, it can only be interesting performance “food”
Congratulations! Looking forward to getting a copy.
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.
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!
> 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.
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.