I am having a high overflow rate for sort and hash join. Heap memory sets as following :
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 51200
Sort list heap (4KB) (SORTHEAP) = 5120
I have increased them double but no changes on the overflow rate...Any idea where to look and solve the issue?