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.
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.