I have an AIX LPAR with Live Partition Mobility, and when I move this LPAR from one box to another, I would like to be able to free the RAM used by Oracle on the fly, is this possible?
For example, if I have the LPAR with 64GB RAM on use and I move it over a box with 48GB RAM, can I tell Oracle to drop some schemas or tables from RAM to be able to move over to the 48GB machine???
I know it can be done with a stop/start of Oracle DB via editing Oracle's config files, but it would be fantastic to automate it fully and on the fly.
Thanks in advance.
So, If I start up an instance without MEMORY_MAX_TARGET, but set a MEMORY_TARGET of say 60GB, can I afterwards setup a MEMORY_TARGET of 48GB and Oracle will adjust accordingly??
Or MEMORY_TARGET is just to increase RAM, but not to decrease it???