Database parameter table (minimum values) - HxGN EAM - 12.0.1 - Installation & Upgrade - Hexagon

HxGN EAM Oracle Database Installation & Upgrade

Language
English
Product
HxGN EAM
Search by Category
Installation & Upgrade
HxGN EAM Version
12.0.1

Parameter

Size

OPEN_CURSORS

1024

SESSION_CACHED_CURSORS

100

MEMORY_TARGET

If using Automatic Memory Management, specify the MEMORY_TARGET parameter.

For a single instance, allocate 40 percent of the total RAM. Afterward, use the Oracle memory advisors to determine the optimal amount of memory for your installation. If excessive paging occurs, reduce the size of this parameter. See Oracle RDBMS installation documentation for more information on the maximum memory sizes for your platform.

SGA_TARGET

If using Shared Memory Management, specify the SGA_TARGET parameter.

For a single instance, allocate 40 percent of the total RAM. Afterwards, use the Oracle SGA memory advisor to determine the optimal amount of SGA memory for your installation. If excessive paging occurs, reduce the size of this parameter. See Oracle RDBMS installation documentation for more information on the maximum SGA size for your platform.

PGA_AGGREGATE_TARGET

If using Shared Memory Management, you may specify the PGA_AGGREGATE_TARGET parameter. Start with a value of 512M.

Use the Oracle PGA memory advisor to determine the optimal amount of PGA memory for your installation. If excessive paging occurs, reduce the size of this parameter

JOB_QUEUE_PROCESSES

10

QUERY_REWRITE_ENABLED

TRUE

COMPATIBLE

19.0, 18.0, 12.2.0, or 12.1.0 depending on the version of the database installed

NLS_LANG

LANGUAGE_TERRITORY. Character set

See the discussion in the section labeled "Pre-installation considerations" for the appropriate character set.

REMOTE_DEPENDENCIES_MODE

SIGNATURE

RESULT_CACHE_MAX_SIZE

Should be set to 0 for any edition other than Oracle Enterprise Edition. If using Enterprise Edition, start at 64MB.