Database - RAC/Scalability (MOSC)

MOSC Banner

Using AMM, sga throwing error of "unable to allocate 32 bytes of shared memory"

edited May 28, 2014 12:00PM in Database - RAC/Scalability (MOSC) 8 commentsAnswered

I am using Automatic Memory Management. I have set the parameters as :-

memory_max_target big integer 10G
memory_target big integer 9G
sga_max_size big integer 1G
sga_target big integer 0
 
sga_max_size is not set to null. If i am not wrong it takes it as a minimum value of sga and can expand upto memroy_target.When i check from v$sgainfo it shows


SQL> select * from v$sgainfo;

NAME                      BYTES RES

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

Fixed SGA Size          2235000 No

Redo Buffers           14024704 No

Buffer Cache Size     167772160 Yes

Shared Pool Size      834666496 Yes

Large Pool Size         4194304 Yes

Java Pool Size         37748736 Yes

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