Database Administration (MOSC)

MOSC Banner

Database 10g on Windows 2008 R2 : ORA-04031 when using automatic memory management

edited Mar 30, 2015 10:02AM in Database Administration (MOSC) 5 commentsAnswered

Hi,

I've got the error ORA-04031 : unable to allocate 3896 bytes of shared memory.

I've got that error since I set SGA_TARGET equal to SGA_MAX_SIZE

If I revert to SGA_TARGET=0, then the error no more occurs.

How do you explain that ?

Here are the memory parameters of my database (in Mb) :

Buffer Cache Size    108

Java Pool Size    48

Large Pool Size    8

Shared Pool Size    204

log_buffer    6

pga_aggregate_target    50

sga_max_size    396

sga_target    0

Rgds,

Frederic

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