Oracle SQL Plan operation: PX SEND

The PX SEND operation corresponds to a DFO: it indicates that data is sent from on parallel execution server to another

Thus, the parent operator is either

• PX RECEIVE or
• PX COORDINATOR

PX SEND has exactly one child row source.

Options I have seen together with th PX BLOCK operation are

• 1 SLAVE
• BROADCAST
• HASH
• HASH (BLOCK ADDRESS)
• HASH (RANDOM)
• HYBRID (ROWID PKEY)
• HYBRID HASH
• HYBRID HASH (SKEW)
• QC (ORDER)
• QC (RANDOM)
• RANDOM LOCAL
• RANGE
• ROUND-ROBIN

In a plan_table, the value of the column distribution is populated exactly for records where the operation is equal to PX SEND.