D Performance Related Configurations for RBI Contractual

Follow the below steps for setting performance related configurations for RBI Contractual:

1. Parameter Settings OracleDB Configuration File OFSAAI provides enabling of Parallelism and setting of DOP for every DML sessions invoked by the applications. These parameters are listed in the OracleDB Configuration file (OracleDB.conf) located in the DB layer of the OFSAAI Installation. Navigate to the path $FIC_HOME/ficdb/conf, to access the file. Modify the values for the below parameters:

   CNF_PARALLEL_QUERY=ENABLE

   CNF_PARALLEL_DML=ENABLE

   CNF_DEGREE_OF_PARALLELISM=2

   CNF_PARALLEL_DEGREE_POLICY=MANUAL

   Note:

   The CNF_DEGREE_OF_PARALLELISM value can be 40% of the available parallel threads per CPU on the database server.
2. Parameter Settings for SETUP_MASTER Table
   1. In the SETUP_MASTER table in the atomic schema, update the below mentioned component codes:

      PARAMNAME PARAMVALUE

      DT_PARALLEL_ENABLE Y

      DT_PARALLEL_DOP 2

      Note:

      The component value set against the component code DT_PARALLEL_DOP should be same as the CNF_DEGREE_OF_PARALLELISM parameter value set in the OracleDB configuration file as mentioned in step 1 Parameter Settings for OracleDB Configuration File.
   2. Enable the gather stats by setting the component code “GATHER_TABLE_STATS” as “Y” in the setup_master table.
   3. Update the Atomic Schema name for the component code “GATHER_STAT_OWNER” in the setup_master table.

      Note:

      You can turn-off the configuration, by disabling the gather stats by setting the component code “GATHER_TABLE_STATS” as “N” in setup_master table.
3. Parameter Settings for Configuration table

   In the configuration table in config schema, update the below mentioned component code:

   PARAMNAME PARAMVALUE

   QRY_OPT_USE_ROWID Y

4. Partition the table FLI_LRM_INSTRUMENT based on the n_run_skey.
5. Disable all the foreign key constraints for the table FSI_LRM_INTRUMENT.