Set the initialization parameters for the database instances

When creating each InForm Oracle Instance, use the following initialization parameters in the init.ora file.

Database initialization parameters

Parameter	Production server values	Development server values
memory_target (starting values)	Small trial: 1.5 GB Large trial: 10 GB Mega trial: 25 GB	Up to 80% of memory available to the Oracle database
db_block_size	16384	16384
db_files	Database dependent.	Database dependent.
open_cursors See Note 1.	150	150
processes See Note 1.	150 (or maximum number of concurrent processes)	50
session_cached_cursors See Note 4.	150	150
streams_pool_size	200M	200M
job_queue_processes	5 minimum: 1 job for each study (the job to update PF_HEARTBEAT table every minute in each study schema) and 1 job for each propagation, plus streams’ minimum requirement of 2 and Oracle MTS’s requirement of 1)	5 minimum: 1 job for each study (the job to update PF_HEARTBEAT table every minute in each study schema) and 1 job for each propagation, plus streams’ minimum requirement of 2 and Oracle MTS’s requirement of 1)
sessions	Derived: (1.1 * PROCESSES) + 5	Derived: (1.1 * PROCESSES) + 5
log_archive_dest	Recommended: $ORADATA/ARCHIVE Defaults: $ORACLE_HOME/dbs	Recommended: $ORADATA/ARCHIVE Defaults: $ORACLE_HOME/dbs
_job_queue_interval	1	1
filesystemio_options See Note 3	SETALL	SETALL
workarea_size_policy See Note 2.	auto	auto
parallel_max_servers	3	3
optimizer_adaptive_features	FALSE For Oracle Database 12.1 only.	FALSE For Oracle Database 12.1 only.

Note 1: These parameters might need to be adjusted depending on the demands on the database that are created by the InForm application and Streams.

Note 2: Although AUTO is default, parameter is needed to ensure proper AMM functioning.

Note 3: Enables both direct I/O and asynchronous I/O where possible.

Note 4: Up to the value of the open_cursors parameter.