Links (6-SEP)

Unsorted links to different papers, presentations, etc.

SQL 101: Interpreting Query Execution PlansIggy Fernandez
Quick Wins in Optimized Analytical Processing Capabilities of 11g Release 2Husnu Sensoy
Cost Based Query TransformationsRiyaj Shamsudeen
Enhanced Subquery Optimizations in Oracle – Oracle
Cost-Based Query Transformation in Oracle (ppt) – CBO team


  1. Posted June 13, 2012 at 14:14 | Permalink | Reply

    Было б супер если добавили книги которые были интересны\стоит почитать

  2. Posted June 14, 2012 at 23:40 | Permalink | Reply

    Hi Anton

    as you may see my blog is not in Russian, so I’ll reply in English.
    (to those who don’t understand Russian, the question is about the books recommendations)

    I don’t read many Oracle books – most of the information comes to me from In my opinion there are not many Oracle books worth reading for people interested in performance:
    * TOP. This is a must read. The only problem with it is missing part 2 called Advanced TOP written by Tanel Poder. There’s also a fundamental book by Cary Millsap and Jeff Holt called Optimizing Oracle Performance which is usually suggested for reading, but I wouldn’t recommend it unless you were not bored by maths in high school.
    * One of Tom Kyte’s books – you can download Expert Oracle Database Architecture for free from RedGate
    * Oracle Core by Jonathan Lewis
    It’s enough, I think.
    If you need perfect Oracle book reviews, then no doubt you have to go to Charles Hooper’s blog. He reads a lot of books on Oracle and posts excellent reviews.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: