Database Parameters

The table below lists the database parameters and the values that must be set for Oracle Argus Insight.

For those parameters that require a numeric value, the table below lists the minimum value recommended. You may need to increase the value depending on your system configuration and the number of cases. It is the responsibility of the database administrator to monitor the system and adjust the database parameters as necessary.

Table 2-1 Database Parameters for Oracle Argus Insight

Database Parameter	Required Value
COMPATIBLE (for Oracle Database 12c)	12.2.0.1 or later
CURSOR_SHARING	EXACT
JOB_QUEUE_PROCESSES	10 (Minimum value recommended)
NLS_LENGTH_SEMANTICS	CHAR
OPTIMIZER_MODE	ALL_ROWS
OPTIMIZER_SECURE_VIEW_MERGING	TRUE
PARALLEL_MAX_SERVERS	Minimum value recommended based on the total number of cases: Small (< 30,000 cases): 16 Medium (30,000 to 200,000 cases): 32 Large (200,000 to 1,000,000 cases): Default Extra Large (> 1,000,000 cases): Default
PGA_AGGREGATE_TARGET	Minimum value recommended based on the total number of cases: Small (< 30,000 cases): 0.5 GB Medium (30,000 to 200,000 cases): 2 GB Large (200,000 to 1,000,000 cases): 3 GB Extra Large (> 1,000,000 cases): 4 GB
QUERY_REWRITE_ENABLED	TRUE (if computing statistics regularly) FALSE (if not computing statistics regularly)
SGA_MAX_SIZE	Greater than or equal to the value of the SGA_TARGET parameter.
SGA_TARGET	Minimum value recommended based on the total number of cases: Small (< 30,000 cases): 1 GB Medium (30,000 to 200,000 cases): 2.5 GB Large (200,000 to 1,000,000 cases): 3.5 GB Extra Large (> 1,000,000 cases): 4.5 GB The 32-bit architecture allows for 4 GB of physical memory to be addressed. DBAs should verify the maximum addressable RAM for their respective architectures.
UNDO_MANAGEMENT	AUTO
WORKAREA_SIZE_POLICY	AUTO
DB_BLOCK_BUFFERS (in MB) / DB_CACHE_SIZE	Leave set to the Oracle default value
DB_BLOCK_SIZE(in bytes)	Leave set to the Oracle default value
QUERY_REWRITE_INTEGRITY	Leave set to the Oracle default value
SHARED_POOL_SIZE	Leave set to the Oracle default value