1)项目在执行过程中,总是报OutOfMemory错误,调查后发现是pga设置过小。
SQL>show parameter sga
NAME TYPE VALUE
----------------------------------------------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 20G
sga_target biginteger 20G
SQL>show parameter pga
NAME TYPE VALUE
----------------------------------------------- ------------------------------
pga_aggregate_target big integer 15G
2)修改Oracle内存大小。需要修改以下参数:
sga_max_size
sga_target
pga_aggregate_target
memory_target
memory_max_target