|
Parameter type: |
Integer |
|
Parameter class: |
Static |
|
Default value: |
Operating system dependent. |
|
Range of values: |
2148 to 65535 (64 K - 1) |
|
Oracle Parallel Server: |
Multiple instances must have the same value. |
|
PARALLEL_EXECUTION_MESSAGE_SIZE specifies the size of messages for parallel execution (formerly referred to as parallel query, PDML, Parallel Recovery, replication).
On most platforms, the default value is 2148 if PARALLEL_AUTOMATIC_TUNING is set to FALSE, and 4096 if PARALLEL_AUTOMATIC_TUNING is TRUE. The default value is adequate for most applications. Larger values require a larger shared pool. Larger values result in better performance at the cost of higher memory use. For this reason, replication gets no benefit from increasing the size. |
|
Note: When PARALLEL_AUTOMATIC_TUNING is set to TRUE, message buffers are allocated out of the large pool. In this case, the default is generally higher. |
