In order to overcome the memory issues, I would review the "JVM Configuration" section of the [Denodo Admin and Development Best Practices](https://community.denodo.com/kb/view/document/Denodo%20Admin%20and%20Development%20Best%20Practices?category=Best+practices) article.
Based on that, I would increase the memory of the Virtual DataPort Server or the Virtual DataPort Administration Tool. Besides, if you have memory issue with the query then I recommend you to refer to the following documentations
* [Memory Management](https://community.denodo.com/docs/html/browse/latest/vdp/administration/memory_management/memory_management#memory-management)
* [Configuring the Memory Usage and Swapping Policy](https://community.denodo.com/docs/html/browse/latest/vdp/administration/server_configuration/configuring_the_memory_usage_and_swapping_policy/configuring_the_memory_usage_and_swapping_policy#configuring-the-memory-usage-and-swapping-policy)
Hope this helps!