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

Author: (USA) Thomas Kyte
Publisher:
Publish Date: 2006-10-01
Features: This book is an authoritative guide on the Oracle 9i and 10g database architecture, covering 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 fully utilizes specific examples to introduce each feature, not only discussing what each feature is but also explaining how it works, how to use it to develop software, and common pitfalls. This book is intended for all developers or DBAs involved in Oracle database applications. Whether you are a programmer or a DBA, to create and manage stable, high-quality Oracle systems, you ultimately need to understand the Oracle database architecture. This book is undoubtedly the authoritative guide to Oracle databases, embodying decades of valuable experience and profound insights from the world's Oracle expert Thomas Kyte. The book provides an in-depth analysis of the Oracle database architecture, including files, memory structures, and the underlying processes that constitute the Oracle database and instance. 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 that can be used to optimally utilize these physical structures. When introducing each feature, the author fully utilizes specific examples to illustrate, not only discussing what each feature is but also explaining how it works, how to use it to develop software, and covering related common pitfalls. This book can help you unlock the full potential of Oracle technology. Undoubtedly, this is one of the most important Oracle books and is absolutely worth owning. —Ken Jacobs, Vice President of Product Strategy (Server Technologies), Oracle Corporation
This book is an authoritative guide on the Oracle 9i & 10g database architecture, covering 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 specific examples to fully introduce 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 related common pitfalls. This book is intended for all developers or DBAs involved in Oracle database applications. Whether you are a programmer or a DBA, to create and manage stable, high-quality Oracle systems, you ultimately need to understand the Oracle database architecture. This book is the authoritative guide to Oracle databases, embodying decades of valuable experience and profound insights from the world's Oracle expert Thomas Kyte. The book provides an in-depth analysis of the Oracle database architecture, including files, memory structures, and the underlying processes that constitute the Oracle database and instance. 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 that can be used to optimally utilize these physical structures. When introducing each feature, the author fully utilizes specific examples to illustrate, not only discussing what each feature is but also explaining how it works, how to use it to develop software, and covering related common pitfalls.