This book is the authoritative book on Oracle 9i and 10g architecture database, covering all the most important Oracle architecture features, including files, memory structures and processes, locks and latches, transactions, concurrency and multi-version, tables and Indexes, data types, and partitioning and parallelism, and makes full use of specific examples to introduce each feature, not only discussing what each feature is, but also explaining how it works, how to use this feature to implement software, and related Common pitfalls.
This book is intended for all developers or DBAs engaged in Oracle database applications.
Whether you are a programmer or a DBA, to create and manage a stable, high-quality Oracle system, you ultimately need to understand the architecture of the Oracle database.
This book is the unquestionable authoritative guide to the Oracle database, embodying decades of valuable experience and a wealth of insights from Thomas Kyte, the world's top Oracle expert. The book provides an in-depth analysis of the Oracle database architecture, including files, memory structures, and the underlying processes that make up Oracle databases and instances. It then discusses important database topics such as locking, concurrency control, transactions, redo, and undo, and explains the importance of these contents. Finally, the physical structures in the database, such as tables, indexes, and data types, are analyzed, and techniques for optimal use of these physical structures are introduced.
When introducing each feature, the author makes full use of specific examples to illustrate, not only discussing what each feature is, but also explaining how it works, how to use it to implement software, and covering common pitfalls.
Expand
