Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions is the definitive book if you're a developer or DBA who works with Oracle-driven database applications. This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book.
One of the world's foremost Oracle experts, Thomas Kyte covers every important feature and function of the database: the importance, inner workings, proper usage, and pitfalls if handled incorrectly. This book will show you how to program correctly with the Oracle database and exploit its feature-set effectively. As a result, you will be able to build fast, effective, scalable, and secure Oracle applications.
Great Book for Develoepr & DBA
This book explains basic & advance about Oracle database and He wrote about his experience, that's great ;)
I suggest Oracle Developer & DBA read this book. I believe this book is helpful,,.
One of the best book of Oracle DB
this book is the base book for every programmer in oracle, which explains the main architecture principles of this DB system by intelligible language of Tom Kyte, the Oracle guru.
recommended but flawed
I recommend this book, more so if you are new to industrial strength relational databases of today (keeping in mind this review is in June 2009) and if you are new to Oracle. My main complaint is that the author spends too much time paying the `faint praise` to Microsoft SQL Server which spoils the book and fills up extra pages. I think the author should have concentrated on just Oracle 9/10 and left the competitive/comparison talk to Oracle sales (which I get download for free) - in context of this book it is not relevant. BTW, much of what the author says about SQL Server is not correct or no longer correct since release of SQL 2005 in CY2005, and SQL Server 2008 in CY2008. I hope the next edition of this book only talks about Oracle and how it works and leaves the other databases out.
must read for Oracle user
This is THE best book for anyone who uses Oracle. I've read it several times. And I still learn from reading it. I couldn't find anything better. Well, the document is thorough (good for reference), but too damn long to read from cover to cover.
Must Have Book For Anyone Oracle
If you work with the Oracle database, or write software that utilizes the Oracle database, you must read this book and apply the knowledge therein to utilize the database to its highest potential. The majority of developers would probably learn a lot about Oracle just by reading through the first chapter. I would recommend anyone who assumes the database is a black box simply to store data to read this book if they want to effectively use Oracle.
This book is not a `how-to` or a `check your syntax` reference manual, but I find myself going back to it time after time for answers concerning design, or production problems that I have encountered. I think the book acts as this sort of reference inherently because of the nature of the author's step by step detail of each problem domain. For example, in the chapter on concurrency and multi-versioning, the author is explaining Oracle's read consistency model. In the code examples, he shows you how to quickly and easily prove exactly how Oracle works by giving the code sample to open one session, perform tasks, then open another session and perform tasks to see for yourself exactly what happens in different scenarios. You can believe what he says in this book is true, simply because he puts the code right in front of you, and even provides all of the code samples from the book online for free on the Apress website.
The author provides in this book details on all aspects of Oracle database. You get a full explanation of the architecture of the database system itself, to behavior of the database such as locking, concurrency, transactional controls. After you understand what the database does, the book goes into details of how to use it. A typical Oracle book, including the Oracle reference, will just give you the options that you have, for example, listing the types of tables that are available for use. What this book does is give you complete detailed analysis of each implementation, along with examples and common pitfalls. It will help you choose the right tool for each implementation.
This is not a DBA handbook! Kyte often writes something to the effect of `but I don't want to get into the details of the DBA world`. While it is not a detailed reference or handbook for DBAs, it still provides the best overview of the Oracle database that I have read anywhere, and would do all DBA's a favor to read it.
Of all the books in the pile on my desk, this one stays near the top!