- It indicates that your developer didn’t perform. right. He played with parallel query without knowing what he does.
- It eats your memory and produces unnecessary process on your system. If your system is not loaded anyway the impact may be minimal. But still you waist system resources and on a loaded system the impact may be considerable.
【Oracle】-PX Deq Credit: send blkd
Just a few days ago a got to two Oracle DBAs discussing why the have so much “PX Deq Credit : send blkd” on a system. And if that is causing their performance problems.
The are some blog on the internet claiming it has to do with qc distribution and what ever.
But in many cases, especial if you experince huge waits on “PX Deq Credit : send blkd” the explanation can be much simpler. But first some background information.
If a query is run in parallel there is a query coordinator (QC) and the query slaves. The slaves do the actual work an send the result to the query coordinator. This is done through message buffers which you specified with the parallel_execution_message_size.
This buffer exists in the large or in the shared pool depending how PARALLEL_AUTOMATIC_TUNING is set.
Metalink states about the PX Deq Credit: send blkd event
This is considered as idle wait event.
You should investigate the sender (decode the senderid).
There is no general advice to reduce the waitime for this event.The process wishes to send a message and does not have the flow control credit. Process must first dequeue a message to obtain the credit. Indicates that the receiver has not dequeued and/or completely consumed the prior message yet.
From that statement you could believe that is a idle even an you don’t need to care.
In this case the waits were cause by a query which look similar to this:
insert into tablex values (select /*+ parallel(32) */ from tabley);
Now it pretty clear from where the waits are coming. Since parallel query is enabled by default, but parallel dml is disabled, you feed a single insert process with 32 slaves. the insert process can never consume that much.
So the question is now, does that indicate a performance problem?
Yes, I does!
What could you do now?
- Don’t run the sub query parallel - it will not run faster, but it does not waits resourced.
- Enable parallel DML. This is not that easy. You would to have verify if your application can work with parallel dml, because there are many restrictions.
- Just ignore it. If you don’t have a performance problem there is no need to fix it.
原文地址:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/645199/viewspace-686775/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【Oracle】並行等待之PX Deq Credit: send blkdOracle並行
- 查詢gv$session引發大量的PX Deq Credit: send blkd事件Session事件
- 【Oracle】並行等待之PX Deq Credit: need bufferOracle並行
- 【Oracle】並行等待之PX Deq: Join ACKOracle並行
- 【Oracle】並行等待之PX Deq: Execution MsgOracle並行
- 【Oracle】並行等待之PX Deq: Execute ReplyOracle並行
- 【Oracle】並行等待之PX Deq: Signal ACKOracle並行
- 【Oracle】並行等待之PX Deq: Table Q NormalOracle並行ORM
- Wait Event "PX Deq: Execution Msg"AI
- oracle send mailOracleAI
- Bug 27223075 - Wait for 'PX Deq: Join Ack' when no active QC but PPA* slaves shoAI
- Oracle stored procedure to send emailOracleAI
- [Developer] Oracle send mail procedure(2)DeveloperOracleAI
- Credit Management(SD)
- oracle hint_px_distribute_push_subq_px_join_filter_qb_name_rewriteOracleFilter
- CSS · 0.1px,0.2px......0.9px,1px效果CSS
- Credit block & Stock resevedBloC
- Send MailAI
- XMLHttpRequest send()XMLHTTP
- oracle parallel並行及px檢視viewOracleParallel並行View
- 【Oracle】gv$px_session 檢視介紹OracleSession
- [原創]How to send patch files by git send-mailGitAI
- [和堅FRM2筆記]信用風險CR-5 Credit Risks and Credit Derivatives筆記
- Reblock after Credit block releasingBloC
- 【Oracle】並行等待之PX Idle WaitOracle並行AI
- px等待事件事件
- SAP Difference between Credit memo and subsequent debits/credits
- Probable reasons when Credit check is not working
- django send_mail功能DjangoAI
- IPC send completion sync
- IPC Send timeout detected
- ORACLE 9I RAC IPC Send timeout detected問題處理Oracle
- 【ASK_ORACLE】Oracle RAC報錯“ipc send timeout”的原因以及解決辦法Oracle
- sublime px -> rem sassREM
- Credit limit change request and new enterprise serviceMIT
- 用ffsend使用Firefox SendFirefox
- mail can't send title on SolarisAI
- Order-level sales credit total () must equal 100%.