Oracle Database - parallel_execution_message_size parameter

Card Puncher Data Processing


The Parallel servers communicate among themselves and with the Query Coordinator by passing messages via memory buffers.

If you execute a lot of large operations in parallel pa, it’s advisable to reduce the messaging latency by increasing the parallel_execution_message_size (the size of the buffers).

By default the message size is 2K. Ideally you should increase it to 16k (16384).

However, a larger value for parallel_execution_message_size will increase the memory requirement for the shared pool so if you increase it from 2K to 16K your parallel server memory requirement will be 8 X more.

Documentation / Reference

Discover More
Card Puncher Data Processing
Oracle Database - (Parallel|PX) Server

Execution Thread in Oracle. Parallel server are the individual sessions that perform work in parallel in a parallel SQL execution. PX server processes can be easily identified on the OS level, for...

Share this page:
Follow us:
Task Runner