Configuring the JDE.INI Settings

The following are required settings and recommended values in the jde.ini file to achieve optimized session management on Oracle Database:

[DB SYSTEM SETTINGS]
UseOracleDBConnectionPool=1
PingConnection=1 
DBConnectionTimeout=60
IdleRequestTimeout=1
OracleMaxCursorBufferPercent=1
OracleDBStatementCacheSize=10

Important: For the Sales Update program (R42800), ensure you set the value for PingConnection as 0.

Note: It is recommended to set the value of OracleMaxCursorBufferPercent as 90 when you are not applying ESU using Deploy Software Update on Web (R96701W).

[WORKFLOW]
CleanupFrequency=30
TimeoutDelay=30
WFEnvironmentMax=0

[RECYCLING]
krnlRecycleElapsedTime=12:00

[SECURITY]
BootStrapEnvRefreshInterval=1800