Specify Database Session Level Parameters

You can define session-level parameters using the Session_Parameters.conf file.

The Session_Parameters.conf file contains ALTER SESSION statements that must be set while a connection is established. You can sopecify and valid Oracle session setting. It is a single file that contains parameter specification for different Infodoms, separated by an INFODOM parameter. The first parameter in the file is the INFODOM parameter that identifies the DB parameters for that particular Infodom. Followed by that, enter the session settings for second Infodom that again starts with the INFODOM parameter.

# The file specifies the database session level parameter settings for better performance # of model upload process. The db session will be set with the following statements mentioned:

# Parameter settings for Infodom 1
 INFODOM = <INFODOM_NAME1>
 #<alter session statement1;>
 #<alter session statement2;>
 #For example,
 #<alter session set db_cache_size=200G;>
 #<ALTER SESSION FORCE PARALLEL DML PARALLEL 49;>
 # Parameter settings for Infodom 2
 INFODOM = <INFODOM_NAME2>
 #<alter session statement1;>
 #<alter session statement2;>
 #For example,
 #<alter session set db_cache_size=200G;>
 #<ALTER SESSION FORCE PARALLEL DML PARALLEL 49;>
 #End of Parameter settings for Infodom 2

Note:

• The alter session statements mentioned in the Session_Parameters.conf file must adhere to the privileges of the respective OFSAA users.
• Every ALTER SESSION statement must start in a new line and need not end with a semicolon (;) component takes care of it.
• The syntax of the ALTER SESSION statements is validated against the syntax tree of Oracle DB to ensure credibility and to protect from any vulnerability. If the syntax fails, the model upload operation will fail.
• The statements RESUMABLE, SYNC, and CLOSE DB LINK are not supported.