What is the Optimum Memory Configuration For Running Oracle R Scripts?
(Doc ID 2190736.1)
Last updated on AUGUST 23, 2022
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Current configuration on Exadata severs:
Is it recommended to apply this new configuration? Which are the optimum values?
We are trying to execute some scripts that can't run with the first memory configuration
These scripts are R language scripts, created with ore.scriptCreate function. We think the process fails when the database running with the script is too big. So we want to try to increase the max memory size on Exadata.
We have seen this blog:
We know how to change the memory settings of our Exadata servers. We are asking about a optimum configuration of these settings.
For example: We have a script that can't run with MAX_VSIZE 10GB. We increase it to 30GB and it runs Ok.
Our question is: Are this 30GB optimum? Which is the 'official' best configuration? Do you have an optimum interval configuration (for example 10GB to 20GB)?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document