Name

PARALLEL_EXECUTION_MESSAGE_SIZE

Synopsis

Value: 2148-65535

Default: operating system dependent

Specifies the size in bytes of messages for parallel execution. On most systems, the default is 2148 if PARALLEL_AUTOMATIC_TUNING is FALSE and 4096 if it is TRUE. Multiple instances must have same value. Larger values result in better performance at the cost of higher memory use.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.