Resolving Oracle ORA-32690: Hash Table Infrastructure ran out of memory

If you are getting ORA-32690 error when doing large join statements, you can resolve the issue with the following tips.