Strange error when resizing MEMORY_TARGET

From: De DBA <dedba_at_tpg.com.au>
Date: Tue, 15 Jan 2013 17:15:01 +1000
Message-ID: <50F501F5.1000301_at_tpg.com.au>



G'day

I am running into the most stupefying error. The version is 11.2.0.3.3, OS is solaris 11, in a local zone. The zone has 72G of RAM and 72G of swap allocated. The memory parameters are:

memory_max_target = 20G
memory_target = 7G
shared_pool_size = 1G

sga_target = 0
pga_aggregate_target = 0

I need to *grow* the memory_target to 16G. This should be possible, as the database is already running and has pre-allocated the 20G (as far as I can see).

I execute:

SQL> alter system set memory_target = 16G;

and receive error:

ORA-02097: parameter cannot be modified because specified value is invalid ORA-00846: could not shrink MEMORY_TARGET to specified value.

What baffles me is that Oracle seems to think that *growing* the memory target from 7G to 16G involves *shrinking* it. Has anyone seen this before and found an explanation? I cannot bounce this 24/7 database to change the memory target size, is there a work-around?

Cheers,
Tony

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 15 2013 - 08:15:01 CET

Original text of this message