Search notes:
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 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.
TODO
The PX SEND operation corresponds to a DFO (Data Flow Operation).