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: