Study database parameters—Different database instances

In a DiffDB environment, the Reporting and Analysis module requires you to add or modify several study database parameters. The following table shows the adjustments that must be made to these parameters. All settings are necessary for both production and development servers.

Additionally, it is recommended that you review the processes and sessions parameters, which are not mandatory for the Reporting and Analysis installation.

For more information, see the Oracle database document, Oracle Streams Recommendations.

Database parameters for a diffdb environment

Parameter	Value	Comments
AQ_TM_PROCESS	1	Must be set on both the study database and the reporting database (streams processing might hang if set to 0).
global_names	TRUE
job_queue_processes	5 minimum	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)
log_archive_dest	Recommended: $ORADATA/ARCHIVE Defaults: $ORACLE_HOME/dbs	You must enter at least one destination.
log_archive_dest_state_1	ENABLE	This enables the archive log destination (log_archive_dest_1). You must enter a state for every destination.
open_links	Four minimum	Four minimum is recommended by Oracle for Streams.
parallel_max_servers	10	Minimum: 3 dependent on the number of parallel apply and/or capture processes.
timed_statistics	TRUE	Recommended by Oracle for collecting elapsed time information for Streams.
_job_queue_interval	One	Recommended by Oracle for Streams.