The Oracle parameters and settings listed in this topic are essential when using the Automation Engine. All other parameters affect primarily the database and are in the database administrator's purview.
| Parameter | Required value |
|---|---|
| commit_logging | Do not set or IMMEDIATE |
| commit_wait | Do not set or WAIT |
| db_block_size | >=8192 |
| disk_asynch_io | TRUE |
| dml_locks | >= 500 |
| filesystemio_options | SETALL |
| fixed_date | NONE |
| instance_type | RDBMS |
| log_buffer | >5MB <20MB |
| memory_max_target | 2/3 of the Server memory |
| memory_target | 2/3 of the Server memory |
| nls_comp | BINARY |
| nls_sort | BINARY |
| open_cursors | >=500 |
| optimizer_dynamic_sampling | 2 |
| optimizer_mode | ALL_ROWS |
| pga_aggregate_limit | >= 2GB |
| processes | >150 |
| resource_limit | FALSE |
| sga_max_size | Max. 2/3 of the Server memory |
| sga_target | Max. 2/3 of the Server memory |
| skip_unusable_indexes | TRUE |
| star_transformation_enabled | FALSE |
| statistics_level | TYPICAL or ALL |
| undo_management | AUTO |
| undo_retention | 900 |
See also: