You can configure the Incorta memory space after installation. By default, Incorta configures a memory space in the start.sh file. In that file Incorta configures the maximum memory that Java allocates and then manages the memory inside of that instance.
To review the memory used by Incorta and the various Incorta users use the top command to list the memory contents.
The result is a list of all users and their memory resources. Of interest here is:
- Process IDs
- User associated with the PID
- VIRT which is the virtual memory consumed
- RES which is the residual or remaining memory
More information is available about the process by grepping for the process ID.
Ps -ef | grep 24813
The result displays the memory configuration along with the location of the home directory.
In this case,
-Xms is the minimum amount of memory and -Xmx is the maximum. Note
that the startup script only calls for Java to allocate the memory. Incorta
handles memory management. Note also that you can have multiple Incorta
instances with different process IDs.
You can further drill into memory and its configuration using the Tomcat server status tool. This tool shows the memory pool which matches the Xms and Xmx numbers, and the memory allocation by process.
Select Server Status to drill into the processes and their memory settings.
The PS Eden space is the working space for loading Incorta data. PS Old Glen is the Incorta data memory pool. When data usage reaches 80 to 90 percent you are running out of memory.
Note: The Tomcat manager is an option. It is not installed by default. Incorta recommends only installing the Tomcat manager inside of your firewall, for dev and UAT environments only. Incorta does not recommend installing this outside of your firewall or on your production environment.
The initial memory allocation is determined during installation. The amount of memory needed by your implementation is determined by the amount of data you have. During the planning stage, configure for 35GB plus the amount of data you have.
The memory settings can be modified in the startup.sh file by modifying the -Xms and -Xmx settings line in the start.sh (start.bat for Windows) file located at /incortaHome/:
export JAVA_OPTS="-Xms20480m Xmx20480m -Dfile.encoding=UTF-8"
Incorta Analytics compresses the data on ingestion. Typical compression rates vary between 1-3x, depending on the cardinality of the data. In addition to the data memory requirements Incorta Analytics also requires 30 percent working memory and indices. With Oracle E-Business Suite data, we recommend a conservative compression rate of 1.5x, which includes all the required memory for running Incorta Analytics.
The following table provides a sample of an Oracle E-Business Suite environment and sizing information for the Incorta Analytics E-Business Suite Accelerators. Note that only columns with analytical value are imported, not the full tables.
|Table Name||Source Size (GB)||Incorta Size (GB)||Rows (M)|
Incorta Analytics stores data on disk in a compressed format with compression rates between 1-10x, and 2x for EBS data. Incorta Analytics High Availability configuration requires double the disk space.