Set the initialization parameters for the database instances

Depending on your environment, you might need one, two, or three database instances (the study, the Reporting and Analysis module, and Cognos 10 BI can each use an instance).

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

Note: Additional parameter settings are required if your installation includes Cognos 10 BI and the Reporting and Analysis module in a DiffDB environment (your study and reporting databases are in separate database instances). For more information, see Study database parameters—Different database instances.

Database initialization parameters

Parameter	Production server values	Development server values
memory_target	Average trial: 1500 MB 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	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

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