Oracle Database 10g Insider Solutions Book Review

Shortcuts and Best Practices

Oracle Database 10g Insider Solutions is divided into 5 parts, Getting Started with Oracle Developer, Quick Wins using Oracle Database 10g, Tuning Oracle Database 10g, Scaling and Availability with Oracle Database 10g and Using Oracle Database 10g Utilities and Other Advanced Features.

Oracle Database 10g Insider Solutions introduces you to all the latest features available in Oracle Database 10g Release 2. Oracle Database 10g Insider Solutions is said to pick up where other books leave off by highlighting tips, tricks, shortcuts and best practices of Oracle Database 10g.

Oracle Database 10g Insider Solutions is a book for DBAs or for Oracle developers who want to learn more about the DBA side of Oracle, although this is not really an introduction to becoming a DBA at it covers quite in-depth DBA concepts.

Oracle Database 10g Insider Solutions begins by giving you an overview of the latest Oracle 10g features and how to install Oracle on Unix/Linux as well as how to recover from a bad install and how to upgrade. Other concepts such as the Undo Advisor, Segment Advisor and the Memory Advisor. The first part concludes with everything you need to know about RMAN.

Part 3 covers everything about tuning the database including the Automatic Database Diagnostic Monitor (ADDM), and how to get the most out of the in-built SQL advisors and finally to how to get the best out of the Cost Based Optimiser (CBO).

Part 4 covers RAC, Grid and Automatic Storage as well as Cluster Ready Services and Service Workload Management. Part 5 covers Data Pump Enhancements, External Table Enhancements and Advanced Data Pump Features.

Oracle Database 10g Insider Solutions is a good book for DBAs and it includes a great deal of tips that can be used with your Oracle 10g Database, just to note that a number of great tips are included inside red boxes on certain pages of the book.

Oracle Database 10g Insider Solutions does seem to cover specific areas of the job of a DBA using Oracle 10g, so make sure it covers the topics you are interested in reading and using.

All the code contained within the book can be downloaded from the SAMS website