Each operation is performed in parallel, if possible. Oracle executes the statement as a sequence of operations.The parallel execution coordinator obtains as many parallel execution servers as needed (determined by the DOP) from the server pool or creates new parallel execution servers as needed.The SQL statement's foreground process becomes a parallel execution coordinator.If the optimizer targets the statement for parallel processing, the following sequence of events takes place: You can specify the number of parallel execution servers required for an operation in various ways. When a user issues a SQL statement, the optimizer decides whether to execute the operations in parallel and determines the degree of parallelism (DOP) for each operation. A parallel execution coordinator cannot coordinate, for example, a parallel query and a parallel DML statement at the same time.
The parallel execution coordinator and the parallel execution servers can only service one statement at a time. After the statement has been processed completely, the parallel execution servers return to the pool. These parallel execution servers remain with the operation throughout job execution, then become available for other operations. If necessary, Oracle can create additional parallel execution servers for the operation. When executing a parallel operation, the parallel execution coordinator obtains parallel execution servers from the pool and assigns them to the operation. The initialization parameter PARALLEL_MIN_SERVERS specifies the number of parallel execution servers that Oracle creates at instance startup. When an instance starts up, Oracle creates a pool of parallel execution servers which are available for any parallel operation.
CAN I UNDO A PARALLELS UPDATE FULL
The Oracle server can use parallel execution for any of the following:įor example, table scans, index full scans, and partitioned index range scans.įor example, nested loop, sort merge, hash, and star transformation.ĬREATE TABLE AS SELECT, CREATE INDEX, REBUILD INDEX, REBUILD INDEX PARTITION, and MOVE SPLIT COALESCE PARTITIONįor example, INSERT AS SELECT, updates, deletes, and MERGE operations.įor example, GROUP BY, NOT IN, SELECT DISTINCT, UNION, UNION ALL, CUBE, and ROLLUP, as well as aggregate and table functions. For example, a bank might use parallelized batch programs to perform millions of updates to apply interest to accounts. During off-hours, however, parallel execution can effectively process high-volume batch operations. OLTP systems also benefit from parallel execution, but usually only during batch processing.ĭuring the day, most OLTP systems should probably not use parallel execution. Parallel execution provides the greatest performance improvements in DSS and data warehousing environments. In fact, parallel execution may reduce system performance on overutilized systems or systems with small I/O bandwidth. If your system lacks any of these characteristics, parallel execution might not significantly improve performance.
Introduction to Parallel Execution Tuning Miscellaneous Parallel Execution Tuning Tips.Monitoring and Diagnosing Parallel Execution Performance.Tuning General Parameters for Parallel Execution.Initializing and Tuning Parameters for Parallel Execution.Introduction to Parallel Execution Tuning.This chapter covers tuning in a parallel execution environment and discusses:
0 kommentar(er)
