欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

PXDeq:ExecutionMsg,PXDeq:ExecuteReply等待事件

程序员文章站 2022-06-12 19:53:57
...

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.