Developers are going nuts using /*+parallel/* hints setting values at 25 and more on an 8 CPU Itaniu
Is there a rule of thumb on the number of processes I can tell them not to exceed? Such as no more than 8 on an 8 CPU box? I am seeing waits like this Waiting for event "PX Deq Credit: send blkd" in wait class "Other" accounted for 94% of the database time as a result.
0