- Shopping Bag ( 0 items )
Posted January 31, 2011
Pro Oracle Database 11g Administration is a great book
On the back cover of this book it says "Pro Oracle Database 11g Administration is a task-oriented guide to managing complex database environments using Oracle Database11g".Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
The thing I like most about this book is that it lives up to this promise. The book covers all aspects of Oracle Database 11g Administration. It starts with installation and implementation, goes through database management, understanding and managing users/security, architecture, etc. It has several great chapters on RMAN. I cannot think of any area that is not covered.
I really like the "task-oriented" approach. For every topic, the author provides step-by-step instructions, complete with scripts for accomplishing each task. Something very nice is that he discusses alternatives for accomplishing tasks, the pros and cons of alternatives and then says how he likes to do it and why. For me, this approach provides a real-world practicality.
If there is one thing I would have liked, that is not present, it would be a separate section devoted to 11g features. Although the author discusses what is specific to 11g, it is scattered throughout the book, within the relevant topic chapter. My style is that I would like a separate section, in addition to this, that summarizes new features.
The last chapter of the book talks about troubleshooting and auditing. This is where a dba needs to act quickly and effectively. I think this is where most dba's can do better and where this book can help. The book addresses identifying the most common issues and identifying them quickly. Again, the author provides great step-by-step instructions in the sequence that they should be performed. He gives the exact commands (sql and os) that should be entered, why the command is used and how to view the results. There are also scripts that automate some of this. There is even a very nice script that lets you view the alert log from anywhere on the server. This script, like many of the provided scripts work on any server with no alterations (using functions, etc.). The author again tells you his personal methodology and approach to troubleshooting, which I think really adds a lot of substance to the material.
Overall, I think this is a great book. By providing step-by-step approaches, the scripts, and the author's own methodology for addressing these tasks, I think this will be a valuable and unique addition to any library.