Oracle Parallel Processing

By Sanjay MishraTushar MahapatraJonathan Gennick, et al.

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 Oracle8 i. 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. This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 156592701X
• ISBN13: 9781565927018
• Release Date: August 2000
• Publisher: O'Reilly Media
• Length: 268 Pages
• Weight: 1.30 lbs.
• Dimensions: 0.7" x 7.1" x 9.2"

Customer Reviews

Good overview on the subject.

Better overview on the subject I havre read.

Well Done!

There are not many books available, except for Oracle Documentation, on the topic of Oracle Parallel Processing and Parallel Server. Trying to learn the parallel processing concepts from documentation is not that easy. This book offers an excellent introduction to the world of Oracle Paralell Processing. Some parts may be rehash of Oracle documentation but then Oracle Parallel Server and Parallel Processing concepts are quite...

Well done . . .

This is a excellent book that goes over what you need to know about Oracle Parallel Processing. The documentation is clear and concise. If additional information is need, references to Oracle Documentation are noted throughout the book. Picking this book up just for the Parallel Execution chapters (Ch 3 - Ch 5) is worth it even if you are not using Oracle Parallel Server.

An Excellent Book of O'reilly

I refer this book as a Parallel Processing and Parallel Server MADE EASY. If you are a serious Oracle DBA then this book is for you. This book is the single point of Source for many of PARALLEL Processing/Server related questions. Use this book to boost your system performance. This is the only book all database professionals need to start working with Parallel Processing and Parallel Server. Every Oracle DBA should read and...

Oracle Parallel Processing

Good effort. This is the first book dedicated to Oracle Parallel Processing. Very good information about OPS and OPS tuning. Could have used a little more description on the OS configuration steps for OPS.