The A.60.04 DBA Settings screen offers the option to assign dedicated rollback segments to specific Smart Materials jobs. Use of this option requires that one or more rollback segments with sufficient space are created and brought online. Furthermore, all directories that Smart Materials needs for its log files should be configured correctly in the instance initialization parameter file (init.ora).
If you are going to perform imports with a significant amount of data, you should also make sure that the shared pool size and the database block buffer cache are sized adequately to achieve optimal performance. If you already have a large amount of BOM data present in your Smart Materials database, you should consider using the cost based optimizer with a mode of FIRST_ROWS, and also perform a full analysis of the M_SYS schema on a regular basis; otherwise, import performance may drop. Please refer to the sample init.ora file that is provided with the Smart Materials Oracle Database Installation. Furthermore, it is possible to specify the optimizer mode as well as the sort area size that OMI should use on a per-job basis by setting parameter values for OMI_OPTIMIZER_MODE and OMI_SORT_AREA_SIZE on the A.60.04 DBA Settings screen.