Best way to set environment variable ORACLE_SGA_PGSZ=16m

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
We need to start an Oracle  VDB using Large pages.
We used a template to modify the configuration of the VDB
We tried to set
ORACLE_SGA_PGSZ=16m
in  delphix/.profile and in  /etc/environment.
VDB starts but Large pages are not used when provisioning VDB from the GUI.
If we shutdown immediate and restart the VDB with delphix user, Large pages are used.

Where is the best place to set ORACLE_SGA_PGSZ variable so it can be used by delphix user when Delphix engine  starts the VDB ?.
Photo of Marie Labidoire

Marie Labidoire

  • 550 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Phani Maddipatla

Phani Maddipatla, Employee

  • 70 Points
Official Response
Marie,

Unfortunately, the only workaround at this time is to (re)start the database manually. The other workaround(using BASH_ENV) that you have mentioned will require changes on the Delphix side so that the scripts(non-interactive shell) used for starting the database will set the BASH_ENV variable. It is a possible solution for the Delphix enhancement that I had mentioned in the previous update. But there are ssh configurations where setting User level environment variables is prohibited over ssh and hence the above approach will not work there. Delphix Engineering is looking into a solution for this but there is no timeline yet on when this will be available though.

Hope that answers your question and please do not hesitate to get back to me if you need further clarifications.

Thanks,
Phani