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.
Chapter 1 Introduction
About Parallel Processing
Parallel Processing for Databases
Parallel Processing in Oracle
Overhead for Oracle Parallel Processing
Requirements for Oracle’s Parallel Features
Chapter 2 Architectures for Parallel Processing
Software Architectures of Parallel Database Systems
Oracle’s Parallel Processing Architecture
Oracle Parallel Execution
Chapter 3 Parallel Execution Concepts
What Is Parallel SQL?
How Parallel Execution Works
Chapter 4 Using Parallel Execution
Parallel Data Loading
Parallel Replication Propagation
Chapter 5 Monitoring and Tuning Parallel Execution
Dynamic Performance Views
Using EXPLAIN PLAN to View Parallel Execution
Tuning Tips for Parallel Execution
Automatic Tuning of Parallel Execution in Oracle8i
Oracle Parallel Server
Chapter 6 Oracle Parallel Server Architecture
OPS and Oracle Instances
Synchronization Between Instances
OPS Impact on Database Files
Integrated Distributed Lock Manager
Group Membership Service
Rollback Segments in OPS
Chapter 7 Administering an OPS Database
Creating an OPS Database
Starting and Stopping an OPS Database
Managing Instance Groups
Backing Up an OPS Database
Recovering an OPS Database
Chapter 8 Locking Mechanisms in OPS
Lock Types in OPS
Parallel Cache Management
PCM Lock Types
PCM Lock Allocation Parameters and Verification
PCM Lock Allocation Guidelines
Chapter 9 Storage Management in OPS
Using Free Lists and Free List Groups
The PCTFREE Parameter: Reserving Free Space
Using Reverse Key Indexes
Chapter 10 Monitoring and Tuning OPS
OPS Performance Views
Dynamic Performance Views
Monitoring PCM Locking
Monitoring Overall Statistics
Monitoring and Tuning IDLM
Oracle Performance Manager
Chapter 11 Partitioning for OPS
When Is Partitioning Needed?
Changing Your Partitioning Scheme
Chapter 12 Application Failover
Maintaining a Failover Database
Planning for Failover with OPS
Chapter 13 Parallel Execution in OPS
How Parallel Execution Works with OPS
Instance Groups for Parallel Execution
Appendix Appendix: Case Studies
Case Study 1: An OLTP Application on an SMP Platform
Case Study 2: An OLTP Application on a Cluster
Case Study 3: A DSS Application on an MPP Platform
Tushar Mahapatra has been a software developer and consultant since 1987 and has worked on a variety of OLTP and DSS projects using the Oracle database. Presently, as a database architect for a Fortune 500 company, he is responsible for the design, implementation, and deployment of applications in an Oracle Parallel Server environment. He also runs a consulting company that provides database design, application development, and database administration services for Oracle databases. Tushar has a bachelor of science degree in electrical engineering, a master of technology degree in industrial management, and a master of science degree in computer science and management. He lives in New Jersey with his wife Sasmita and their two children. He can be reached by email at email@example.com.
Sanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. He has been involved in the design, architecture, and implementation of many mission-critical and decision support databases. He has worked extensively in the areas of database architecture, database management, backup / recovery, performance tuning, Oracle Parallel Server, and parallel execution. He has a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the coauthor of Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly & Associates). Presently, he works as a database architect at Dallas Based i2 Technologies, and can be reached at firstname.lastname@example.org.
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The illustration on the cover of Oracle Parallel Processing is a wasp and a wasp nest. The paper wasp (Polistes fuscatus aurifer and Polistes apachus) is the most common of the social wasps. As their name implies, paper wasps make their nests out of paper, or rather, chewed wood and plant particles combined with saliva to make a paper-like paste. Wasp nests are usually the size of a person's outstretched palm and are shaped like an umbrella. They hang under building eaves, roofs, and tree branches and are constructed with multiple tiers of vertical cells. A single nest houses anywhere from 15 200 wasps.
Paper wasps are social insects, indicated both by their caste system (made up of one or more queens, a few drones, and many workers) and by their food sharing. Drinking only liquids (either flower nectar or other insects' blood), adult wasps share their food with the young by regurgitating it. The young then produce a saliva that is 50 times more nutritious than the original nectar. Adults complete the cycle by receiving that saliva from the young.
Female wasps are capable of inflicting a painful sting on humans, causing swelling and redness for a few hours. However, 3% of people may go into anaphylaxis from a sting. This life-threatening allergic reaction causes hives, severe swelling, blocked airways, circulatory failure, and possibly death. Approximately 50 people die in the U.S. each year from anaphylactic shock caused by a sting. Wasps, unlike honeybees, can sting multiple times. Honeybees can sting only once since their stingers have barbs, causing the stinger to remain in the skin and detach from the bee, effectively killing it.
Paper wasps are one of the less aggressive wasps. They rarely attack people and only do so to defend their nests (which happens if nests are in highly-trafficked areas such as windows, doors, or even fruit trees in orchards). All social wasps are beneficial to humans in that they prey on many harmful, plant-feeding, and nuisance insects. For this reason, social wasp colonies should be protected, though preferably in areas uninhabited by humans. Jeffrey Holcomb was production editor for Oracle Parallel Processing. Norma Emory was the copyeditor. Maureen Dempsey proofread the book. Emily Quill and Madeleine Newell provided quality control. Matt Hutchinson provided production support. Bruce Tracy wrote the index.
Edie Freedman designed the cover of this book. The cover image is a 19th-century engraving from the Dover Pictorial Archive. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font.
Alicia Cech and David Futato designed the interior layout based on a series design by Nancy Priest. Mike Sierra implemented the design in FrameMaker 5.5.6. The text and heading fonts are ITC Garamond Light and Garamond Book. The illustrations that appear in the book were produced by Robert Romano and Rhon Porter using Macromedia FreeHand 8 and Adobe Photoshop 5. This colophon was written by Jeffrey Holcomb.
Whenever possible, our books use a durable and flexible lay-flat binding. If the page count exceeds this binding's limit, perfect binding is used.
Comments about O'Reilly Media Oracle Parallel Processing:
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 use this book. I strongly recommend this EXCELLENT book.
It completely touched all about Parallel Processing Architecture, Concepts, Tuning with numerous examples. It covers OPS architecture, Administration, Concepts, Storage, Tuning, Partitioning, Failover in depth in simple words. For me this is RIGHT BOOK AT RIGHT TIME.