Oracle Database Discussions

Hi,

I am trying to modify the SYSTEM Parameters "MEMORY_MAX_TARGET" AND "MEMORY_TARGET"  in Oracle version 12.1.0.2.0. I read the blogs and discussions on these two parameters and altered using SPFILE scope.

ALTER SYSTEM SET MEMORY_MAX_TARGET = 2048 SCOPE=SPFILE;

ALTER SYSTEM SET MEMORY_TARGET = 2048 SCOPE=SPFILE;

OUTPUT:

SYSTEM SET ALTERED;

SYSTEM SET ALTERED;

However, when I ran the show parameters SQL, it still shows 0 as value. Am I missing any step here to set these values? Please suggest.

NAME                                               TYPE        VALUE                                                                                               

-------------------------------------------------- ----------- ----------------------------------------------------------------------------------------------------

memory_target                                      big integer 0          

memory_max_target                             big integer 0    

Thanks