Oracle Argus Safety Database Instance Parameters (Recommended)

We recommend that you evaluate each site before installation and on an ongoing basis to determine whether these settings are suitable for your business needs.

Note:

Oracle Argus Safety database compatible parameter should be set as the <current version>.

#	Database Parameters	Small(under 30,000 cases reported per month)	Mid-Sized(30,000 to 200,000 cases reported per month)	Large(200,000 to 1,000,000 cases reported per month)	Very Large(over 1,000,000 cases reported per month)
1	MEMORY_TARGET	10 GB	16-24 GB	32-64 GB	>64 GB
2	PROCESSES	Expected concurrent users + 100	Expected concurrent users + 100	Expected concurrent users + 100	Expected concurrent users + 100
3	MEMORY_MAX_TARGET	>= value set for MEMORY_TARGET	>= value set for MEMORY_TARGET	>= value set for MEMORY_TARGET	>= value set for MEMORY_TARGET
4	OPTIMIZER_SECURE_VIEW_MERGING	FALSE	FALSE	FALSE	FALSE
5	CURSOR_SHARING (Mandatory)	EXACT	EXACT	EXACT	EXACT
6	WORKAREA_SIZE_POLICY	AUTO	AUTO	AUTO	AUTO
7	JOB_QUEUE_PROCESSES	25	25	25	25
8	DB_BLOCK_SIZE (bytes)	8192	8192	8192	8192
9	NLS_LENGTH_SYMANTICS (Mandatory)	CHAR	CHAR	CHAR	CHAR
10	GLOBAL_NAMES	TRUE	TRUE	TRUE	TRUE