Database Memory & 4030/4031 (MOSC)

MOSC Banner

SGA_TARGET vs MAMORY_TARGET Oracle 11gR2

edited Oct 10, 2018 10:17AM in Database Memory & 4030/4031 (MOSC) 14 commentsAnswered
Hi

In a database 11g (11.2.0.1.0)

The memory parameters have this values:

memory_max_target                   big integer 48G
memory_target                            big integer 48G
pga_aggregate_target                 big integer 10G
sga_target                                   big integer 25G
pre_page_sga                             boolean     FALSE
sga_max_size                             big integer 48G


What implication has set the two parameters (memory_target and sga_target set)?.
I Know that the ideal in 11g is set sga_target = 0, but with this values what is the result?, oracle take the memory_target or sga_target?

Best Regards.

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