Art of Programming in Oracle9i&10g

Author: Kate
Publisher:
Publish Date: 2006-01-01
Features: "This book can help you unleash the full potential of Oracle technology. Without a doubt, it is one of the most important Oracle books, absolutely worth owning." – Ken Jacobs, Vice President of Product Strategy (Server Technologies), Oracle Corporation. This book is an authoritative guide on the architecture of Oracle9i, 10g databases, covering all the most important Oracle architecture features, including files, memory structures, and processes, locks and latches, transactions, concurrency, and multiversion, tables and indexes, data types, as well as partitioning and parallelism. It uses specific examples to fully illustrate each feature, not only discussing what each feature is but also explaining how it works, how to use this feature 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, ultimately requires understanding the architecture of the Oracle database. This book is an authoritative guide on Oracle database truth, condensed from the decades of valuable experience and numerous insights of the world's Oracle expert Thomas Kyte. The author provides an in-depth analysis of the Oracle database architecture, including files, memory structures, and the tiered 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 their significance. Finally, it analyzes the physical structure of the database, such as tables, indexes, and data types, and introduces the techniques to optimally use 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 is an authoritative guide on the architecture of Oracle9i, 10g databases, covering all the most important Oracle architecture features, including files, memory structures, and processes, locks and latches, transactions, concurrency, and multiversion, tables and indexes, data types, as well as partitioning and parallelism, and uses specific examples to fully illustrate each feature, not only discussing what each feature is but also explaining how it works, how to use this feature to develop software, and related common pitfalls. This book is intended for all developers or DBAs involved in Oracle database applications.