Preparing your Oracle environment - Oracle parameters

You will set certain Oracle parameters to prepare your Oracel environment for migration.

Change the Oracle parameter settings as described in the following table. The theory behind these changes is that the database is playing more of a Decision Support System role instead of an OLTP role as part of the upgrade process.

Table 1. Oracle parameters
Parameter Name Setting
pga_aggregate_target 2 GB
log_checkpoint_interval (disabled)
db_file_multiblock_read_count 32
fast_start_mttr_target 1800s
sga_max_size 4.5 GB