Oracle Parallel Server Features
Setting up an Oracle Parallel Server (OPS) can be tedious.
You must install and configure each node and then connect it to the whole. Once created, the nodes must be monitored to assure that each one is being used efficiently. Special programming is required to take advantage of parallel processing.
Oracle8i added enhancements to simplify the setup, use, and tuning of an OPS system.
This module covers these enhancements, as well as some basic concepts of OPS that were new to Oracle8 and carry over to Oracle8i.
By the end of the module, you will be able to:
- Identify Oracle8i enhancements and Oracle8i new features for Parallel Server
- Use the OPS Assistant to define Parallel Server instance
- Recognize correct syntax for parallel DML
- Create a parallel query for an object table
- Describe the background processes in an Oracle Parallel Server system
- Describe the IDLM utility
- Use the
DBMS_JOB package to control job execution
- Define node affinity
- Describe how to set up TAF
The next lesson gives you an overview of OPS enhancements.
Oracle Parallel Server: A database server consisting of multiple database instances that act as a single database.
The OPS distributes activity by concurrently executing transactions on multiple database instances. Each database instance can be located on a different machine to maximize use of resources.