Specify Database Session Level Parameters
The Session_Parameters.conf file contains ALTER SESSION statements that must be set while a connection is established. Any valid Oracle session setting can be specified. 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
When the database session for Model Upload is initiated, the particular database session is initialized with the specified settings. The settings are valid till the session ends.
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.
- RESUMABLE, SYNC and CLOSE DB LINK statements are not supported.