What is the Optimum Memory Configuration For Running Oracle R Scripts?
Last updated on NOVEMBER 02, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
We have this configuration in our Exadata severs:
And we need this configuration:
Is it recommended 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 an 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)?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms