RelationalDBDesign RelationalDBDesign

Parallel Server   «Prev  Next»
Lesson 4 Using parallel queries on object tables
ObjectiveCreate a parallel query for an object table.

Using Parallel Queries (On object ables)

A new feature of Oracle8i allows you to execute a parallel query on object tables and object-relational tables that contain object type columns. The types of queries supported are the same as those for relational tables. In addition, parallel queries support special features of object types such as methods, constructors, object views, and access to attributes of object types. A prerequisite of parallel execution of a query on an object table is a MAP MEMBER function[1]. A MAP MEMBER function is defined on the object type and used to sort object records quickly. We will look at how to create this kind of function for an object type in the simulation.
In the following simulation, you will create a MAP MEMBER function in an object type. Next, you will create a parallel query for an object table that is based on the object type and MAP MEMBER function you created.

Answer File 1
1) Answer File 1
Answer File 2
2) Answer File 2
Answer File 3
3) Answer File 3
Answer File 4
4) Answer File 4
Answer File 5
5) Answer File 5
Answer File 6
6) Answer File 6
Answer File 7
7) Answer File 7
Answer File 8
8) Answer File 8
Answer File 9
9) Answer File 9
Answer File 10
10) Answer File 10
Answer File 11
11) Answer File 11
Answer File 12
12) Answer File 12
Answer File 13
13) Answer File 13
Using Parallel Queries on Object Tables

The following list shows restrictions involving parallel queries of object types:
  1. Parallel queries on nested tables are not supported.
  2. Parallel DML and parallel DDL are not supported with object types.
If the Optimizer determines that the query requires non-parallel execution, no error messages are issued informing you of this choice.
The next lesson covers using the Oracle Performance Manager to monitor global V$views.

Using Parallel Queries on Object Tables - Exercise

Click the Exercise link below to practice creating a query and DML commands for the object table. Using Parallel Queries on Object Tables - Exercise

[1]Map MEMBER function: A function defined as part of an object type to sort or compare object rows with one another.