I have memory_target and memory_max_target set to 6GB, pga_aggregate_target and sga_target set to 0. My sga_max_size is set to 6GB. I'm thinking this was left over from the 10g days. By leaving sga_max_size set to 6G does that leave memory management set to manual and not use AMM?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatic memory management settings
- Thread starter PMSLIC
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question