Using DB_PARAMS to Tune the EP_LOAD_SALES Performance
- by user702295
The DB_PARAMS table can be used to tune the EP_LOAD_SALES performance. The
AWR report supplied shows 16 CPUs so I imaging that you can run with 8 or more
parallel threads. This can be done by setting the following DB_PARAMS
parameters. Note that most of parameter changes are just changing a 2 or 4 into an 8:
DBHintEp_Load_SalesUseParallel = TRUE
DBHintEp_Load_SalesUseParallelDML = TRUE
DBHintEp_Load_SalesInsertErr = + parallel(@T_SRC_SALES@ 8) full(@T_SRC_SALES@)
DBHintEp_Load_SalesInsertLd = + parallel(@T_SRC_SALES@ 8)
DBHintEp_Load_SalesMergeSALES_DATA = + parallel(@T_SRC_SALES_LD@ 8) full(@T_SRC_SALES_LD@)
DBHintMdp_AddUpdateIs_Fictive0SD = + parallel(s 8 )
DBHintMdp_AddUpdateIs_Fictive2SD = + parallel(s 8 )