Database Memory & 4030/4031 (MOSC)

MOSC Banner

ORA-00845: MEMORY_TARGET not supported on this system

edited Mar 1, 2013 9:15AM in Database Memory & 4030/4031 (MOSC) 12 commentsAnswered

Hi everyone


We have 2 node 11.2.0.2 RAC running on Linux X_64
We have 8 GB RAM on the servers so we decided to utilize 5GB of it for Oracle


Here were our settings as related to SGA / PGA


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
memory_max_target                    big integer 2656M
memory_target                        big integer 2656M
pga_aggregate_target                 big integer 0
sga_max_size                         big integer 2656M
sga_target                           big integer 2G

We changed the AMM settings as below:

SQL> alter system set memory_max_target=5120M scope=spfile sid='*';
System altered.

SQL> alter system set memory_target=4096M scope=spfile sid='*';

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