-
LOG_FILE_DEST - Specifies globally in which server directory log files for various Smart Materials programs are created. Can be overridden on A.20.12/13 by supplying a value for the ZX_MAR_LOG parameter.
-
LOG_ONLINE_JOBS - Specifies whether log files for online jobs should be created at all. Activating this option is highly recommended.
-
BOM_IMPORT_PATH - Specifies the global default directory for OMI. Can be overridden on A.20.12/13 by supplying a value for the ZI_OMI_IN parameter.
-
PLUS_EXECUTABLE - Globally specifies the name of the Oracle SQL*Plus program. In OMI, this setting is needed for creating a first-cut import protocol that is spooled out to a file for each job after the main import program finishes.
-
SQLLDR_EXECUTABLE - Globally specifies the name of the Oracle SQL*Loader program. In OMI, this setting is necessary if you want to use SQL*Loader to populate the interface table from flat ASCII files.
-
RBS_OMI - Globally specifies a rollback segment that is dedicated to OMI import jobs. If this setting is not configured, the Oracle server randomly assigns a rollback segment to OMI transactions.
-
OMI_OPTIMIZER_MODE - Specifies the optimizer mode that OMI job execution should use. This value can be CHOOSE, RULE, FIRST_ROWS, or ALL_ROWS. Once the OMI job finishes, the optimizer mode that was in effect before the job started is restored again.
-
SORT_AREA_SIZE - Specifies the sort area size that is available to all SQL statements (including dynamic index creation) that are executed during an OMI job. You can specify a value between 64K and 256MB here. Once the OMI job finishes, the sort area size that was in effect before the job started is restored again.