31 Performance Related Configurations

Follow the below steps for setting performance related configurations for OFS CRA:

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
   1. In the configuration table in Config Schema, update the below mentioned component code:

      PARAMNAME PARAMVALUE

      QRY_OPT_USE_ROWID Y

4. Partition the table FCT_CREDITRISK_ACCOUNT_SUMMARY based on the n_run_skey.