Programming Art of Oracle 9i & 10g: In-depth Database Architecture

Author: (USA) Thomas Kyte
Publisher:
Publish Date: 2006-10-01
Features: This book is an authoritative guide on the Oracle9i and 10g database architecture. It covers all important Oracle architecture features, including files, memory structures, and processes, locks and latches, transactions, concurrency, and multiversioning, tables and indexes, data types, as well as partitioning and parallelism. It utilizes concrete examples to thoroughly explain each feature, not only discussing what each feature is but also how it works, how to use it to develop software, and common pitfalls. This book is intended for all developers or DBAs working on Oracle database applications.
No matter if you are a programmer or a DBA, to create and manage stable, high-quality Oracle systems, you ultimately need to understand Oracle database architecture. This book is undoubtedly the authoritative guide to Oracle database, condensed decades of valuable experience and profound insights from the world's Oracle expert Thomas Kyte. The book provides an in-depth analysis of Oracle database architecture, including files, memory structures, and the underlying processes that constitute Oracle databases and instances. It then discusses important database topics such as locking, concurrency control, transactions, redo and undo, and explains the significance of these concepts. Finally, it analyzes the physical structure of the database, such as tables, indexes, and data types, and introduces the techniques to optimally utilize these physical structures.
When introducing each feature, the author fully utilizes concrete examples to explain, not only discussing what each feature is but also how it works, how to use it to develop software, and covering related common pitfalls. This book can help you unleash the full potential of Oracle technology. Without a doubt, this is one of the most important Oracle books and absolutely worth owning. —Ken Jacobs, Vice President of Product Strategy (Server Technologies), Oracle Corporation
This book is an authoritative guide on the Oracle9i/jaz10g database architecture. It covers all important Oracle architecture features, including files, memory structures, and processes, locks and latches, transactions, concurrency, and multiversioning, tables and indexes, data types, as well as partitioning and parallelism, and utilizes concrete examples to fully explain each feature. It not only discusses what each feature is but also explains how it works, how to use it to develop software, and covers common pitfalls. This book is intended for all developers or DBAs working on Oracle database applications.