The Pakistani Spectator

A Candid Blog

Oracle Parallelism Itching Wait Event

By Shayan Khan • Apr 15th, 2011 • Category: Technology • 2 Comments

Parallelism is near to silver bullet for many of the database operation on huge volume of data. But as is the case with bullets, you have to handle them with care otherwise they could backfire.

PX Deq Credit: send blkd is a wait event you might see in your AWR report if you are running parallel queries. The event PX Deq Credit: send blkd happens when the parallel slaves compete for sending results back to the QC process. The competing slaves time out after 2 seconds. From the AWR reprot, get the avg wait time for PX Deq Credit: send blkd for the parallel slaves and see if it is less than 2 seconds? If it is then probably there is nothing you can much except controlling your parallelism in your application because heavy chances are that you are maxing out on your CPU.

If that is not the case, and your average wait time is higher than 2 seconds, and that is happening frequently and you are watching same patterns again and again in AWR or ASH reports during the high load on the system when the performance is not acceptable, and you believe that you have ample CPU then increase the size of PARALLEL_EXECUTION_MESSAGE_SIZE  parameter and by also keeping the space in large_pool in perspective.


Trackback URL

Click For More Articles By Shayan Khan He lives with his wife, four kids, and a dog in a small town in north-central Massachusetts where he spent four years teaching computing, math, and science at the local high school.
All posts by Shayan Khan
You can follow any responses to this entry through the RSS 2.0 feed.

2 Responses »

  1. [...] at pkhope discusses Oracle Parallelism Itching Wait [...]

  2. Recommeneded websites…

    [...]Here are some of the sites we recommend for our visitors[...]……

Leave a Reply (Read Comment Policy)

TPS has started observing minimal and mainly automatic comments moderation. Our automatic moderation tool tries to moderate comments on the basis of inappropriate keywords. If you feel that your valid and proper comment has been moderated, then please let us know, and we will promptly look into it. If you feel that an inappropriate comment has been ignored by tool, then let us know please, and we will check it. Thanks for your visit and help.

Like this facebook page too for the forms and application. Like page for FORMS and Applications