Parallel queries can be performed on object type tables and tables containing object type columns. Parallel query for object types supports all of the features that are available for sequential queries on object types, including:
Methods on object types
Attribute access of object types
Constructors to create object type instances
PL/SQL and Oracle Call Interface (OCI) queries for object types
There are no limitations on the size of the object types for parallel queries.
MAP function is needed to execute queries in parallel for queries involving joins and sorts (through
BY, or set operations). Without a
MAP function, the query is automatically executed serially.
In all cases where the query cannot execute in parallel because of any of these restrictions, the whole query executes serially without giving an error message.