I started reading this book last week, and I'm half way through right now. But i wanted to write this review because what i found in the book is fairly enough for this.
As the book's tittle expresses it involves examples, recipes, different test cases for almost all topics in the chapters. This is great, because just definitions and descriptions are not enough to fully understand the concept (especially) in a performance tuning book.
Book covers the most important performance tuning topics for an Oracle database. You'll find it useful even you're a developer or a dba. It describes the tuning methods with different aspects. Performance tuning is not like many other Oracle database topics becuse there is not a general "true" many times. A tuning method may halve the job duration in a database, where it may double the time for another database. This is the most important fact that you need to know when searching for tuning recommendations. The data type, database structure is very important in evaluating a tuning method. This book is explaining the tuning methods with almost every aspects. In which conditions we should use it or not and why. Here i want to share some highlighted parts of the topic "Index Clusters" which i think will help you see what i mean.

The major benefit of using clusters is in reduced I/O for accessing data from different tables joined together, reducing even the space occupied by the cluster key that is stored once for all the rows of all the tables participating in the cluster, which have the same key value.

An index cluster works as an ordinary index, speeding up access to the rows with a specific cluster key value.

The benefits of using clusters are reduced when we regularly access a single table of the cluster or when we perform more DML operations—insert, update, and delete—than select. The reason for this performance delay is that storing rows from more than one table in the same database block, forces the engine to read a greater block than in the case of a standard table; full table scan performance is affected by the same issue, which causes poor performance in DML operations. This is because by updating an (eventually) small row in a table of the cluster, all the blocks containing the rows for the particular cluster key affected will be read and manipulated.

if the rows for a cluster key value cannot be stored in few (1-2) database blocks, clusters are not a good choice.

Consider introducing clusters in situations where data is almost static and you often query joined together tables.

Due to the particular storage characteristics of a clustered table, we cannot perform a TRUNCATE TABLE statement, because the database blocks are shared among the tables in the cluster. The only way to eliminate the rows is with the DELETE command. If we need to use the TRUNCATE TABLE statement on a table, clustering is not a choice.

I'm sure readers will learn a lot of useful information from this book. You can find more information and TOC here:

17 Responses so far.

  1. Charles Hooper was reviewing this book for quite some time. The series of his reviews of several parts of the book ran longer than the Melrose Place.
    Review results were .... well, interesting. His blog is here:

  2. I have been struggling to find a good resource to jump into performance topic. Thank you for your review! I am going to order this today.

    Thanks again Emre

  3. Marvelous work.Just wanted to drop a comment and say I am new to your blog and really like what I am reading.

  4. Thank you very much for your good information. As I noted in the given information is very useful to every student who ever want to learn something new.

  5. Felicitari pentru blog.

    Simple sau tunate masinile sunt o nevoie. Cu ceva ani in urma earau un moft.
    Masinile sunt bijuterii ale barbatilor. Femeile cumpara bratari, cercei de milioane de lei, noi barbati ne delectam cu ceva piese, leduri si alte nimicuri.

    Mult noroc in toate.

  6. Sravani says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion HCM Online Training

  7. sushma says:

    Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
    Oracle Fusion Financials Training

  8. raju says:

    Thank you for sharing such a nice and interesting blog.
    Oracle Fusion Financials Online Training

  9. Oracle says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion SCM Online Training

  10. Naga says:

    Very interesting blog, keep posting such an informative post.

    Oracle Fusion Financials Online Training

  11. Awesome post. your article is really informative and helpful for me and other bloggers too

    oracle fusion financials online training

  12. Really excellent information and thank you for giving your valuable information

    oracle fusion scm online training

  13. Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Oracle Fusion Financials Online Training if you want more information.
    Oracle Fusion Financials Online Training

  14. Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article
    Oracle Fusion SCM Online Training

  15. Thank you for sharing such a nice and really very helpful article
    Oracle Fusion HCM Online Training

  16. Very interesting blog Awesome post. your article is really informative and helpful for me and other bloggers too
    Oracle Fusion Technical Online Training

  17. shivani says:

    An astounding web diary I visit this blog, it's inconceivably magnificent. Strangely, in this current blog's substance made point of fact and sensible. The substance of information is instructive.
    Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    oracle Fusion Technical online training

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -