Customer Reviews

Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)

5 star:		(12)
4 star:		(7)
3 star:		(5)
2 star:		(2)
1 star:		(2)

 

 

It didn't seem possible that Mr. Loney could surpass the excellence of his previous books, but I have found "10g: The Complete Reference" to be the most comprehensive and well-written Oracle book on the market today. Most of 10g's new features are complex and can be misapplied if not understood thoroughly. Mr. Loney provides DBAs and developers with clean, concise writing and relevant examples that allow developers and DBAs to exploit the new features of Oracle 10g quickly and appropriately. The beginning sections on Oracle fundamentals should be required reading for all Oracle professionals. His wealth of experience is evident throughout the book. Indispensable for anyone serious about developing or managing Oracle databases.

For those who have seen the prior editions of this book:

The new version is 47 chapters plus the Alphabetical Reference. New chapters include:
Installing Oracle 10g
Upgrading to Oracle 10g (from 9i)
Using the regular expression functions (REGEXP_LIKE, REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_REPLACE)
Using Virtual Private Databases
Using DataPump Export and DataPump Import
Using Flashback Version Queries
Flashback Table (via the Recyclebin)
Flashback Database
Writing dynamic PL/SQL
Case Studies in performance tuning
10g AS
RAC
Grid Management

Additionally, the older chapters have been revised to include coverage of features such as ASM, the Quick Tune options, dynamic memory management, new functions and commands, datatype changes, data dictionary changes, and much much more.

-Kevin Loney.

As a newbie to Oracle, I found the book easy to follow throughout the chapters. Each time digging in more complex matters. This was a great help!

The title says it all. Well there's one additional tidbit of information that's important, there are 1200 pages in this book. In 1200 pages you can include a lot of things. You can include 300 pages on SQL for instance. And some of the new subjects like the new sections on The Grid (that's the g in 10g) are covered here for the first time.

The Grid is coming, as of yet it's just getting started, but in the next edition of this book it'll be a hundred pages, if it isn't a whole book in itself.

As an Oracle professional, at almost any level from developing an application, to tuning the performance, to security, to 'simple' things like installation, this is the one book you need to have on your desk ready for immediate use.

After this, it's kind of hard to say much about this book. You may want individual books on tuning or security or whatever if that is your primarily responsibility, but here in one volume is the basic for the whole thing.

With a 1200+ page book, entitled "The Complete Reference", I would have expected much more information about proper configuration. Properly configuring Oracle (I'm running it on Unix) is no trivial matter and I found this book to be severely lacking. While it seems like a good reference to have (hence 3 / 5 stars), it looks like I'm going to have to look for other resources.

I have used Kevin Loney's texts, both the Reference and the DBA editions on Oracle database from the heady Oracle 7 days and have found them to be most acurate, complete and exceptionally easy to use and to quickly locate required materials. The examples given are very clear and they work!
The 10g texts are remarkable in their coverage and clarity. Many thanks Kevin and keep up the good work !

This sounded like a good book, judging by the reviews here, but being relatively new to the Oracle world, I haven't found this book terribly useful so far. Oracle's docs have been much more helpful and detailed. I was hoping for a book that shared the author's experience and tips and helped the reader make decisions, but this seems to be largely a command reference, covering many topics superficially.

Based on the reviews, I bought this book some time ago. Unfortunately, my colleagues and I have not found much use for it. It covers quite some subjects but rather briefly. There is almost half the book on SQL and PL/SQL which is too much for me for a "Complete Reference" I expected more info on configuring oracle, dataguard, ASM and Enterprise Manager but was disappointed.
For an SQL/PLSQL novice, this must be the reference book, very complete with many examples to guide you. For a DBA already familiar with this language, the book would contain too little specific info on new and important 10g topics such as ASM, dataguard, flashback etc...
Conclusion for me: when I want to look up something on Oracle, I go for OTN manuals or metalink or google instead of this book.

This is the best book about Oracle 10g I have ever used. It can be read from one end to the other getting comprehensive knowledge of Oracle features. Or you can use it as a reference looking up just in one chapter. Each chapter is independent and clearly explain about the topic in such a manner that you can easily understand it even if you have not read the rest of the book.

I would say this is a must have book if your going to use Oracle 10g. As some one else said it is not a book about configuration, it is a book about the features.

I have many of other Oracle 10g books but I think this is best Oracle 10g book on the market it is well-written and comprehensive.
Thanks Mr Loney