1. Using Oracle Data Transforms
  2. Reference
  3. Increase the Memory of ODI Agent

14.6 Increase the Memory of ODI Agent

APPLIES TO: Applicable Data Transforms that is available as a separate listing on Marketplace called Data Integrator: Web Edition.

If the data that you are loading from the source schema is huge, then you may want to increase the memory of the ODI Agent to avoid OutOfMemory exception errors.

To increase the memory of the ODI Agent:

  1. Edit the /u01/oracle/transforms_home/common/scripts/jettyServer.sh file.
  2. Add the java -Xms1024m -Xmx4096m parameter.
  3. Restart the jetty server. Log in as OPC user and execute the following commands:
    ssh -i <path to id_rsa> opc@<Instance IP>
sudo su
systemctl stop|start jettyserver.service
exit

Parent topic: Reference