Home

Technology S
IGS
Database
Fusion Middleware

Applications

Community
Events
Evening Workshops
Training
Membership | Corporate Members
Sponsors

Resources
Morgan's Library
Presentations
Links
Book Reviews
Downloads
Jobs
User Groups
Products | Services

General
Contact Us
About Us
Website Stats
Bylaws
Legal Notices | Terms of Use
Privacy Statement
 
PSOUG book reviews are conducted by a team of three, or more reviewers. Books reviews are be published only if the we believe the book makes a significant contribution and is not just a rehash of existing materials. New listings have a colored background.

The order of the books, below, does not constitute a rating system nor is it intended to convey any information. If we didn't think these books belonged on your bookshelf we wouldn't even mention their names.

Book reviews are ongoing books so please submit suggestions and recommendations.

 
Book Name / ISBN Oracle Insights Tales of the Oak Table
Author /Publisher Mogens Norgaard, Dave Ensor, Tim Gorman, Kyle Hailey, Anjo Kolk, Jonathan Lewis, Connor McDonald, Cary Milsap, James Morle, David Ruthven, Gaja Krishna Vaidyanatha
Review

The cover says: "Eleven leading authorities on Oracle's database engine share their unique insights on how best to exploit the software. We can't think of a better description of this book in which each of the eleven writers has authored a chapter. Here are some of the chapter titles as they speak for themselves.

  • You probably don't tune right
  • Compulsive tuning disorder
  • Testing and risk management
  • Design disasters

Chapter 1 by Dave Ensor alone is worth the price of admission. While this book can be read by the novice ... the more years of Oracle experience you have ... the more valuable this book will be. Enjoy!

 
Book Name / ISBN Practical Oracle 8i / 0-201-71584-8
Author /Publisher Jonathan Lewis
Review Don't let the fact that this book was written for 8i discourage you. If you are one of those developers or DBAs that doesn't need a book for syntax. But rather looking for books to help you make decisions on which syntax to choose, and why, this book is essential. Jonathan's knowledge of Oracle is at the top of the trade and this book contains some of the most valuable advice available anywhere.

With Oracle 8i this book was essential, and it is good enough that it survived without revision through Oracle's 9i. We sincerely hope Jonathan will do a complete rewrite for 10g.
 
Book Name / ISBN Expert one-on-one Oracle / 1-861004-82-6
Author /Publisher Tom Kyte
Review You should not be allowed to put 'developer' and 'PL/SQL' on your resume if you haven't read this book. Tom deals with the most important aspects of working with Oracle ... rarely covered in other books that focus more on syntax than successful implementation of applications utilizing the syntax. The first three chapters are mandatory reading for anyone coming to Oracle from SQL Server, DB2, Informix, or Sybase.

This book is, without a doubt, the most referenced to book on the shelf.
 

Book Name / ISBN

Effective Oracle By Design / 0-07-223065-7
Author /Publisher Tom Kyte

Review

As one PSOUG member recently remarked: "Syntax is boring." And it is. Anyone can go to the web and find the syntax to do something. Knowing what to do, and perhaps more importantly, what not to do is what separates the amateur from the professional.

If you aren't using Oracle to build single-user systems, if you have need to be concerned with performance and scalability, add this book to your reading list. One of the many things we like about this book is the emphasis on testing code for performance and scalability the demonstrations related to hard parses and soft parses, and the fact that some soft parses are softer than others.
 
Book Name / ISBN Oracle In A Nutshell / 0-613912-17-9
Author /Publisher Rick Greenwald, David C. Kreines
Review A good introduction for those new to Oracle.
 
Book Name / ISBN

Oracle Security Step-by-Step / 0-9724273-4-1
Author /Publisher Pete Finnigan
Review If part of your job responsibility is securing databases this book should definitely be on your list. Unlike far too many treatments this book goes far beyond the simple reliance in userid and password and provides hundreds of concrete and specific ideas on where security holes can be found and how to plug them.

The books biggest weakness is the lack of an index. What you are looking for is likely here ... finding it, however, may be a bit of a challenge.
 
Book Name / ISBN

The Art and Science of Oracle Performance Tuning / 1-904347-01-0
Author /Publisher Christopher Lawson
Review The author has written this book from the standpoint that it will be read by DBAs: It should be read by everyone. Developers should not throw any garbage they can write over the cubicle wall and expect their DBA to sort things out after it is implemented in production. So there is a lot of material in here that will be new for developers and should not be, but likely is, new for many DBAs.

One part of this book we really appreciate is the fact that the book is giving advice oriented toward version 9i and beyond rather than rehashing old version 7 - 8i advice that, in many cases, is obsolete. Be sure not to miss the sections devoted to the new magic views such as V$PGA_TARGET_ADVICE.

The one thing this book is missing is DBMS_PROFILER. Hopefully the author will add this critical tuning tool to future editions.
 
Book Name / ISBN

Oracle Database 10g New Features / 0-07-222947-0
Author /Publisher Robert G. Freeman
Review No single book could possibly discuss all of the new features in 10g ... but this book does a commendable job of identifying new features that will most likely be of interest to serious developers and DBAs looking for those features on which they should initially concentrate.

The book assumes you already know the basics so the code samples are designed for someone already familiar with 9i functionality.
 
Book Name / ISBN

Beginning Oracle Programming / 1-59059-286-7
Author /Publisher Sean Dillon, Tom Beck, Tom Kyte, Joel Kallman, Howard Rogers
Review Under review
 
Book Name / ISBN

Optimizing Oracle Performance / 0-59600-527-X
Author /Publisher Cary Milsap
Review Under review
 
Book Name / ISBN

Cost Based Oracle Fundamentals / 1-59059-636-6
Author /Publisher Jonathan Lewis
Review Under review
 
Book Name / ISBN

Performance Tuning 101 / 0-07-213145-4
Author /Publisher Gaja Krishna Vaidyanatha, Kirtikumar Deshpande, John A. Kostelac
Review Under review
 
Book Name / ISBN

PeopleSoft for the Oracle DBA / 1-59059-422-3
Author /Publisher David KurtzOak Table Press
Review Under review
 
 
This is site maintained by the Puget Sound Oracle Users Group. Last Updated: