RelationalDBDesign RelationalDBDesign


Parallel Server   «Prev 

Enable Parallel DML

data-manipulation-language
Data Manipulation Language

Location 1 This command tells Oracle8i to consider all transactions following the command for parallel execution. Use this command, or use hints (see below) to enable parallel execution of specific commands.
Location 2 The table that is modified must be a partitioned table to use parallel execution. The syntax is identical to non-parallel DDL.
Location 3 In general, you should execute only one parallel execution command per transaction - issue a commit between transactions.
Location 4 A parallel UPDATE command uses many more locks than a non-parallel (serial) UPDATE command.
Location 5 This hint tells Oracle8i to use parallel execution of the command with a degree of parallelism set to five. There are many other hints you can use to customize parallel execution, but this is the main one.