db_block_size

8192

db_files

1024

Controls the number of operating system files the database will manage.

In large installations this parameter may need to be set higher.

Changes to this parameter requires cycling the database forcing application down time.

deferred_segment_creation

FALSE

Required due to limitations of import/export.

processes

1500

open_cursors

1000

Monitor this parameter to make sure the value is appropriate to the number of users. A parameter setting that is too low might impact database performance.

session_cached_cursors

1000

Monitor this parameter to make sure the value is appropriate to the number of users. A parameter setting that is too low might impact database performance.

streams_pool_size

1 GB

1 GB is the minimum value required

memory_target

0

sga_target

Only use this parameter for mega trials.

Set to 80% of total_server_memory - (1GB*Number of CPUs+1GB for the server).

In addition sga_max_size should be set to the full amount from the equation.

For example:

If the server has 100GB available and 10 CPUs, then sga_max_size = 100gb-((10CPUs*1gb)+1gb) and sga_target would be 80% of the result as follows:

sga_max_size=89gb

sga_target=71gb

sga_target is only recommended to be used on mega trials as a minimum memory setting in combination with memory_target.

In general it is recommended to use memory_target alone.

_job_queue_interval

1

pga_aggregate_target

3 GB minimum

You may need to increase this value for large studies

_optimizer_cost_based_transformation

LINEAR

For optimal performance, use the default value for this parameter in Oracle 19c

_push_join_predicate

For the trial database, set to TRUE.

For optimal performance, use the default value for this parameter in Oracle 19c

open_links

50

parallel_max_servers

Total number of CPUs + 1

Minimum: 3, dependent on the number of parallel apply and/or capture processes