oracle px execute reply,PX Deq: Execution Msg,PX Deq: Execute Reply等待事件

本文介绍了PXDeq:ExecutionMsg和ExecuteReply所引发的并行任务等待问题,如何通过减少查询的并行度来降低CPU占用。博客建议在检测到过度CPU使用时调整参数,以提升查询效率并避免资源浪费。
摘要由CSDN通过智能技术生成

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.

原文:http://blog.csdn.net/dbaheng/article/details/38496259

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值