What is the Optimum Memory Configuration For Running Oracle R Scripts? (Doc ID 2190736.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

We have this configuration in our Exadata severs:

R_HOME /usr/lib64/R
R_LIBS_USER /u01/app/oracle/product/12.1.0.2/dpdbp01/R/library
VERSION 1.5
MIN_VSIZE 32M
MAX_VSIZE 10G
MIN_NSIZE 2M
MAX_NSIZE 1G

And we need this configuration:

R_HOME /usr/lib64/R
R_LIBS_USER /u01/app/oracle/product/12.1.0.2/dpdbr01/R/library
VERSION 1.5
MIN_VSIZE 32M
MAX_VSIZE 40G
MIN_NSIZE 2M
MAX_NSIZE 10G

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:
https://blogs.oracle.com/R/entry/managing_memory_limits_and_configuring

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)?

 


 

Solution

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