Expert Oracle

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. In it you will find deep wisdom on designing, developing and administering these applications, from one of the World's foremost Oracle experts, Tom Kyte. It covers every important feature and function of the database; why it is important, how it works, how you should use it, and what can happen if you do things the wrong way. It is unique in terms of the technical depth and insight that it provides on each topic.This special signature edition provides a CD containing a searchable PDF of the book as well as a sample chapter from the forthcoming 10g Edition. It also contains a personal introduction from Tom and an intriguing foreword from Dr. DBA, Ken Jacobs.This book will show you how to program correctly with the database and exploit its feature-set effectively. As a result, you will be able to build fast, effective, scalable and secure Oracle applications. TOC:Foreword from Ken Jacobs.- Personal Introduction from Tom.- Introduction.- Setting Up.- Developing Successful Oracle Applications.- Architecture.- Locking and Concurrency.- Transactions.- Redo and Rollback.- Database Tables.- Indexes.- Import and Export.- Data Loading.- Tuning Strategies and Tools.- Optimizer Plan Stability.- Analytic Functions.- Materialized Views.- Partitioning.- Autonomous Transactions.- Dynamic SQL.- interMedia.- C-Based External Procedures.- Java Stored Procedures.- Using Object Relational Features.- Fine Grained Access Control.- n-Tier Authentication.- Invoker and Definer Rights.- Appendix A: Necessary Supplied Packages.- Appendix B: Support and Errata.