PX Deq: Execution Msg

Occurs when a parallel slave is waiting to be told what to do. This is normally considered an idle event, but can cause excessive CPU in some cases.

Solution

Reduce the degree of parallelism in the query if excessive CPU usage is detected.

PX Deq: Execute Reply

Occurs when the query coordinator is waiting for a response from a parallel slave. This is normally considered an idle event, but can cause excessive CPU in some cases.

 Solution

Reduce the degree of parallelism in the query if excessive CPU usage is detected.