| Team Fly | |
FIGURE 9-6. Parallel processing
Generally, not much configuration is required for Oracle Database 10g to perform parallel processing. There are, however, a number of configuration options that are required and will affect the effectiveness of parallelism.
To begin with, parallel processing is enabled by default for DDL (for example, create and alter) and query (for example, select) commands, but disabled for DML (say, insert, update, delete, merge) commands. If you wish to execute a DML command in parallel mode, you must first issue the following command for the session in which the command is to be executed, as in the following.
alter session enable parallel dml;
Several database initialization parameters affect parallel processing. These are shown next.
| Team Fly | |