My Oracle Support Banner

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

Last updated on NOVEMBER 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 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.

Goal

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

Current configuration on  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

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

 


 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.