raghud

hash join uses hash area which means PGA, it also uses TEMP tablespace, also distinct == group by so sort is used, so basically we use

hash join
sort

4030 is related to PGA, the server process cannot get memory from OS, it can be that the server is exhausted of resources or there is a limit memory per process