oracle px execute reply,PXDeq:ExecutionMsg，PXDeq:ExecuteReply等待事件

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

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.

本文原创发布php中文网，转载请注明出处，感谢您的尊重！