Reg. Memory_target parameter setting.
1008431May 14 2013 — edited May 15 2013Hi,
We are planing to upgrade database from 10g to 11g.
Previous sga_max_target and pga_aggregate_target set for the database.
During upgrade we are planning to keep memory_max_target for sga and pga management (AMM).
But in few docs, Have seen some performance issues/memory issues crop up with memory_max_target parameter setting .
Please let me know which one is better AMM or ASMM.
IS Memory_max_target is safe to set in 11g?