Database Administration (MOSC)

MOSC Banner

memory target

Hi,

On 11.2.0.4

what is the difference for performance between:

NAME                 TYPE    VALUE

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

memory_max_target          big integer 0

memory_target            big integer 0

And :

NAME                 TYPE    VALUE

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

memory_max_target          big integer 6G

memory_target            big integer 6G

Which one is better for performance?

Thanks.

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