Oracle Parallelism Itching Wait EventBy 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.
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.