Oracle Parameters

The Oracle parameters and the required 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.

• 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

• omptimizer_mode

  ALL_ROWS

• pga_aggregate_limit

  >=2MB

• processes

  > 150

• resource_limit

  FALSE

• sga_max_size

  max. 2/3 of server memory

• sga_target

  max. 2/3 of server memory

• skip_unusable_indexes

  TRUE

• star_transformation_enabled

  FALSE

• statistics_level

  TYPICALL or ALL

• undo_management

  AUTO

• undo_retention

  900

See also:

• Preparing the AE Database - Oracle
• Recommendations for Oracle
• Automation Engine Database