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