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 |
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: Defaults: |
Recommended: Defaults: |
_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 |
FALSE |
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.