This content has been marked as final. Show 2 replies
What's your OS and available RAM. This error is often misleading analyze, and may indicates there's not enough memory on the host.
It also seems the parallel query is used making a need of huge amount of memory, what's the CPU_COUNT parameter's value ? How many CPUs are on the host ?
If that is "too high", it will create many parallel queries raising that error, you could first try to low down that parameter's value (alter system set cpu_count=xyz).