Database Memory & 4030/4031 (MOSC)

MOSC Banner

Getting error ORA-00846 when we increase MEMORY_TARGET

edited Jan 11, 2017 12:28PM in Database Memory & 4030/4031 (MOSC) 7 comments
Hi,

We face some strange issue today as below :

SQL> ALTER SYSTEM SET MEMORY_TARGET = 8196M;
ALTER SYSTEM SET MEMORY_TARGET = 8196M
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00846: could not shrink MEMORY_TARGET to specified value

Enviroment details
Oracle version : 11.1.0.7

Parameter details :

memory_max_target                    big integer 16G
memory_target                        big integer 4G
pga_aggregate_target                 big integer 0
sga_target                           big integer 0
sga_max_size                         big integer 16G

Current SGA and PGA usage :

SQL> select * from V$MEMORY_DYNAMIC_COMPONENTS where current_size >0;

COMPONENT                      CURRENT_SIZE   MIN_SIZE   MAX_SIZE USER_SPECIFIED_SIZE OPER_COUNT LAST_OPER_TYP LAST_OPER LAST_OPER GRANULE_SIZE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center