Oracle Parallel Processing (Paperback)

Parallel processing is becoming increasingly important to database computing. Databases often grow to enormous sizes and are accessed by huge numbers of users. This growth strains the ability of single-processor and single-computer systems to handle the load. More and more, organizations are turning to parallel processing technologies to give them the performance, scalability, and reliability they need. Anyone managing a large database, a database with a large number of concurrent users, or a database with high availability requirements--such as a heavily trafficked e-commerce site--needs to know how to get the most out of Oracle's parallel processing technologies.

Oracle Parallel Processing is the first book to describe the full range of parallel processing capabilities in the Oracle environment, including those new to Oracle8i. It covers:

• What is parallel processing--features, benefits, and pitfalls. Who needs it and who doesn't? What features does Oracle provide, and what are their requirements and overhead implications? The book answers these questions and presents the various parallel architectures (SMP, or Symmetric Multiprocessing; MPP, or Massively Parallel Processing; clustered systems; and NUMA, or Non Uniform Memory Access).


• Oracle parallel execution--Oracle supports a variety of parallel execution features in the database. The book covers the use, administration, and tuning of these features: parallel query, parallel data loading, parallel DML (Data Manipulation Language), parallel object creation (through DDL, or Data Definition Language), and parallel replication propagation.


• Oracle Parallel Server--Oracle also provides the OPS option, which work to be spread over both multiple CPUs and multiple nodes. This book covers OPS architecture, requirements, administration, tuning, storage management, recovery, and application failover issues.

Oracle Parallel Processing also contains several case studies showing how to use Oracle's parallel features in a variety of real-world situations.

並行處理對於資料庫運算變得越來越重要。資料庫通常會變得非常龐大且被大量使用者存取。這種成長使得單處理器和單電腦系統難以應付負載。越來越多的組織轉向並行處理技術，以獲得所需的性能、可擴展性和可靠性。任何管理大型資料庫、具有大量並行使用者或具有高可用性需求（例如高流量的電子商務網站）的人，都需要知道如何充分利用Oracle的並行處理技術。

《Oracle並行處理》是第一本描述Oracle環境中完整並行處理能力的書籍，包括Oracle8i中的新功能。它涵蓋了以下內容：

- 什麼是並行處理-功能、優點和陷阱。誰需要它，誰不需要？Oracle提供了哪些功能，它們的要求和開銷有哪些影響？本書回答了這些問題，並介紹了各種並行架構（SMP，對稱多處理器；MPP，大規模並行處理；叢集系統；NUMA，非一致性記憶體存取）。
- Oracle並行執行-Oracle在資料庫中支援多種並行執行功能。本書涵蓋了這些功能的使用、管理和調優：並行查詢、並行資料載入、並行DML（資料操作語言）、並行物件建立（通過DDL，資料定義語言）和並行複寫傳播。
- Oracle並行伺服器-Oracle還提供了OPS選項，可以將工作分散在多個CPU和多個節點上。本書涵蓋了OPS架構、要求、管理、調優、儲存管理、恢復和應用程式故障轉移問題。

《Oracle並行處理》還包含幾個案例研究，展示了如何在各種實際情況下使用Oracle的並行功能。