How to revert automatic memory management implimentation?
Hi,
We are using oracle 11.2.0.2 enterprise edition.
Before implementing memory_target and memory_max_target, I saved a copy of our pfile. I then set the two parameters based on sga_target and pga_aggregate_target. I started the database with the right sized memory parameter, and the database uses spfile.
Now I try to revert back to the configuration before AMM is introduced. I started the database using my saved pfile, and created new spfile from the old copy of pfile. When I checked memory_target and memory_max_target, they are both 0. But when I shutdown the database and started it using the new spfile, the two parameter is not 0 any more. It was using the sizes I set when I implemented the AMM.
We are using oracle 11.2.0.2 enterprise edition.
Before implementing memory_target and memory_max_target, I saved a copy of our pfile. I then set the two parameters based on sga_target and pga_aggregate_target. I started the database with the right sized memory parameter, and the database uses spfile.
Now I try to revert back to the configuration before AMM is introduced. I started the database using my saved pfile, and created new spfile from the old copy of pfile. When I checked memory_target and memory_max_target, they are both 0. But when I shutdown the database and started it using the new spfile, the two parameter is not 0 any more. It was using the sizes I set when I implemented the AMM.
0