Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions - Taschenbuch

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. The book is fully revised and covers both the 9i and 10g versions of the database (up to and including 10g Release 2). It also comes with a CD containing a searchable PDF of the 8i version of the book. Thus you have a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, from one of the World's foremost Oracle experts, Tom Kyte. It covers every important feature and function of the database, explaining 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 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:Developing Successful Oracle Applications.- Architecture Overview.- Files.- Memory Structures.- Oracle Processes.- Locking and Latching.- Concurrency Control.- Redo and Undo.- Data Structures.- Datatypes.- Indexes.- Tables and Clusters.- Data loading.- Tuning strategies and tools.- Analytics.- Materialized Views.- Fine-Grained Access Control.- Fine Grain Auditing.- N-tier Authentication.- Invoker and Definer rights.- Advanced Queuing.- DBMS_STATS.- Security.- Using Objects in PL/SQL.