Link to home
Start Free TrialLog in
Avatar of Carlos Ijalba
Carlos IjalbaFlag for Spain

asked on

Can RAM used by Oracle be freed on the fly?

Hi,

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.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Carlos Ijalba

ASKER

Thanks guys,

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???
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Sorry but no.

The online docs typically has everything you need:
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams143.htm#REFRN10285

In a text-based initialization parameter file, if you omit MEMORY_MAX_TARGET and include a value for MEMORY_TARGET, then the database automatically sets MEMORY_MAX_TARGET to the value of MEMORY_TARGET. If you omit the line for MEMORY_TARGET and include a value for MEMORY_MAX_TARGET, the MEMORY_TARGET parameter defaults to zero. After startup, you can then dynamically change MEMORY_TARGET to a nonzero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.
Thanks for your responses.