Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Initialization Parameters, 137 of 188


PARALLEL_EXECUTION_MESSAGE_SIZE

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. 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index