Learn more Shop now Shop now Shop now Shop now Shop now Shop now Learn More Shop now Learn more Click Here Shop Kindle Learn More Shop now Shop Women's Shop Men's

Customer reviews

4.0 out of 5 stars
4.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star

There was a problem filtering reviews right now. Please try again later.

on 13 May 2012
The book is aimed at "helping beginner and intermediate Oracle professionals" (page 2). Presumably that means knowledge equivalent to OCA or OCP qualifications. For the intended market it should be excellent, if (like me) you are OCM, you will learn not that much. But there are some issues.
The good stuff first: chapters 2 (indexes), 6 (explain plan), 7 (hints), 8 (query tuning), 9 (joins), 10 (pl/sql), 11 (parallelism only - ignore the stuff about Exa% and RAC, they can't be covered in just a few pages), 12 (v$ views) and 13 (x$ tables) are excellent and make the book worth the price. They get it the 4 star rating.
Some other chapters (and the 3 appendices) may be interesting, but they aren't essential reading: chapters 1 (new features), 5 (Enterprise Manager), 15 (a system review method), and 16 (some Unix commands).
Three remaining chapters are good, but have problems. Chapter 3 on discs and ASM does go on about placing files on different discs to eliminate contention. This is dreadfully old fashioned, and I assume has been copied from previous versions of the book. I hope everyone knows that best practice is to stripe all your file systems across all your discs. Chapter 4 (initialization parameters) is also out of date: it goes on about tuning with hit ratios, which is very 20th century. Chapter 14 (AWR and Statspack reports) is good as far as it goes, but it misses a critical topic: there is no mention of DB Time and v$sys_time_model, even though this is the first part of a report that many DBAs will go to.
Now the bad stuff. First, the technical editing is poor. All authors make mistakes (I certainly do) and the tech editors are meant to catch them. Just a few incontrovertible examples:
Page 4, the description of Exadata storage indexes is wrong, "...which cells need to be accessed..." should read "...which blocks need to be accessed..." Pages 21,22 include an example of code to set up a flashback data archive, which ends with a query that can't work because it projects a column that isn't in the table. On page 334, the first example can't work because the hint is missing the table name. There are many more like this, I'll send all the ones I spotted to McGraw-Hill for inclusion in the errata sheet. This is not trivial: things like this can be confusing or misleading for the reader: be sure to download the errata.
Second, the bad one: the author is wrong on how redo is generated. Page 147 gives a description of redo which suggests that only committed changes and changes to undo segments generate redo, but that uncommitted changes do not. Page 782 compounds the error by suggesting that redo is no longer written to disc in near-as-damnit real time (and of course it is real time on commit), and page 866 makes it even worse by saying that whole blocks (not change vectors) go to the log buffer (as in release 5, perhaps?). Related to this is the wrong description of the log_buffer parameter (page 204, repeated on 1004) which states that the log buffer is used for "uncommitted transactions in memory". It also says incorrectly that you cannot set the parameter in an spfile. Understanding redo is critical, and is why I chopped a point off the score.
So overall, the book is very good, but read it with your eyes open.
0Comment| 11 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 23 March 2016
This book has been around for some time and it is what it says "a must have for DBA moving to these new products. The book is lengthy but easy to read with good examples. I found it interesting in particular chapter 11 on Exadata and RAC.
Useful read to understand the DBA role and the performance aspects of the Oracle Database.
This book is for DBA's and the other comment I have is it might be nice to include more on the developer perspective? Maybe.
0Comment|Was this review helpful to you?YesNoReport abuse

Need customer service? Click here

Sponsored Links

  (What is this?)