Home
Membership
Meetings
Presentations
Tips, Tools & Scripts .
Book Reviews
Newsletter
Board of Directors
User Group Links
Oracle Links
Group Feedback“
List Servers
Book Reviews
Expert One-on-One Oracle
The first section covers his approach to developing successful applications and Oracle’s internal architecture. His approach is to know how to use the database’s various features to their full capabilities.In the first chapter, the author tells stories, which get the point across that lacking understanding of how the database functions will lead to disaster as you try to grow and scale your system up.As an employee of Oracle, the author offers his insight into the architecture of the Oracle database. He covers the architecture and implementation of various database features such as locking, concurrency control, transactions, etc.The structures part covers the classic Oracle DBA course material on the various files, such as redo files, parameter files, data files, and memory structures, such as Process Global Area(PGA), System Global Area(SGA), User Global Area etc…), and processes, such as the System Monitor(SMON), the Process Monitor(PMON), Log Writer(LGWR) etc. This information is explained very clearly at the beginning of the book.In the second part of this section, the author gets into explaining how and why you would want to use various tools. Such as the Export and Import and SQL Loader. Export and Import can be used to transport tablespaces, and move schemas. In the SQL Loader Chapter the author explains how to update existing rows and insert new rows at the same time using SQL loader.My favorite section is the Tuning Chapters where he explains how to read and analyze SQL Trace files and use the DBMS_PROFILER package, StatsPack and some important V$Views. Rather than rehashing the manuals on the performance tools he analyzes samples from his system and explains the results in great detail.This book contains detailed knowledge of many of the useful Oracle components and when to use and not use them. The author’s approach is unique in that he uses FAQ’s and excellent examples to illustrate each subject rather than rehashing the manuals. Most Oracle books are strictly for reference, this book makes for good reference but also is great reading and covers interesting concepts. Most technical books are very dry & boring, but not this one.Overall, this book provides tons of information. And it should be read from cover to cover. It’s pretty much certain that you will learn a great deal about Oracle from the book, and it will make your work easier. I highly recommend it to everyone who works with Oracle databases. |