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.
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 |