Database Administration (MOSC)

MOSC Banner

Oracle 12c enable automatice memory management

edited Aug 28, 2015 4:54AM in Database Administration (MOSC) 3 commentsAnswered ✓

Hi everybody,

I enabled the automatic memory management by setting the following Values for my database :

memory_target     =     560G

sga_target            =    35G

inmemory_size     =     520G

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

all other memory components are not set.

the database is running, and everything is nice, but I noticed the default buffer cache which managed by oracle is 512M ?

and this value is too low for our DW database.

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

I also create pfile from memory to check the current value, is also still 512M, so is that normal ?

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