My Oracle Support Banner

General Info On ORE Usage And Maintenance (Doc ID 1536515.1)

Last updated on AUGUST 26, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.


Qn1: Library directories of R are owned by root, so any installation of CRAN packages require sysadmin intervention.
Per business policy handing out the root password is not an option.

Is there a way to change ownership of at least one of those directories to a less privileged user so that "application team" could complete this installation on their own?
Qn2: When R is called from the database, with which Unix user's credentials does it execute?
Qn3: How can you monitor R code execution in the database?
Qn4: How can you check parallelism of R execution in the database?
Qn5: How can you monitor R code execution in the OS?
Qn6: Do CRAN packages parallelism or only the ORE supplied packages?
Qn7: Is there a more comprehensive documentation available for ORE?

Right now, the supplied documentation (callable from R) is very brief.
For instance, the documenation for ORE.lm consists of a single sentence stating it's a ORE version of lm.
This is insufficient for our analysts and we would like to learn more about each ORE supplied function.
Qn8: ORE requires an older version of R. 
Many of CRAN packages are already optimized for a newer version of R and won't install.

Is there any compatibility list available, stating which versions of CRAN packages can be installed with ORE?

If there isn't, the only way to install such CRAN packages would be trial and error, which we would rather avoid.
Our server has port 80 blocked and the installation takes place by downloading the packages outside the box and copying them over.


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

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