Lesson 9

This module covered how the features that Oracle8i provides to simplify and optimize the Oracle Parallel Server. In this module, you learned how to:

1. Identify Oracle8i enhancements and Oracle8i new features for Parallel Server
2. Use the OPS Assistant to define Parallel Server instance
3. Recognize correct syntax for parallel DML
4. Create a parallel query for an object table
5. Describe the background processes in an Oracle8i Parallel Server system
6. Use the DBMS_JOB package to control job execution
7. Define disk affinity
8. Describe how to set up TAF

Oracle Parallel Server (OPS) is a legacy product that is no longer being developed or supported by Oracle. It was a cluster-based version of the Oracle Database that allowed multiple nodes to access a single database concurrently. It was replaced by Oracle Real Application Clusters (RAC) which is a more advanced and widely used option for achieving high availability and scalability in Oracle Database environments.

The following terms were defined in this module:

1. Instance affinity: A feature of DBMS_JOB package that limits a job in OPS to one database instance.
2. MAP MEMBER function: A function defined as part of an object type to sort or compare object rows with one another.
3. 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.
4. Transparent application failover (TAF): A feature in Net8 to seamlessly move a user’s session from one instance to another when the original instance fails.

Click the Quiz link below to test your understanding of the concepts presented in this module.

Oracle Parallel Server - Quiz