Model upload is relatively time consuming as the data and model size grows. This enhancement allows you to set database session parameters, according to individual database environment, thus improves the performance of the model upload process.
The configuration file Session_Parameters.conf is available in the $FIC_HOME/conf/dmm folder.
Following are the steps involved:
1. Specify database session level parameter settings in the Session_Parameters.conf file.
2. Set the option to refresh session parameters from configuration files to TRUE, either through command line or UI.
The Session_Parameters.conf file contains ALTER SESSION statements to be set while connection is established. Any valid oracle session setting can be specified. It is a single file which contains parameter specification for different Infodoms separated by an INFODOM parameter. The first parameter in the file is the INFODOM parameter which identifies the DB parameters for that particular Infodom. Followed by that, the session settings for second Infodom comes, which 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 should adhere to the privileges of the respective OFSAA users. · Every ALTER SESSION statement should start in a new line and need not end with a semicolon (;); component will take care of it. · The syntax of the ALTER SESSION statements is validated against the syntax tree of Oracle to ensure the credibility and to protect from any vulnerability. If the syntax fails, model upload operation will fail. · RESUMABLE, SYNC and CLOSE DB LINK are not supported. |