Preparing your Oracle environment - Oracle parameters

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