Database Memory & 4030/4031 (MOSC)

MOSC Banner

[SOLVED] RAC 12.2.0.1, SE - Oracle Linux 7 - MEMORY_MAX_TARGET & MEMORY_TARGET

edited Oct 26, 2021 9:11AM in Database Memory & 4030/4031 (MOSC) 7 commentsAnswered ✓

Good morning,

I've found two similar questions here, but still need someting to be clarified.

pga_aggregate_target is set to 12643M and sga_target to 38016M

Now, I wanna add 32 G RAM (2x16) to this server, and increase the amount of memory for our production instance. According to the current settings, MEMORY_MAX_TARGET and MEMORY_TARGET are not set which means that the current 40 G (38+12) are allocated statically.

Currently, our instance is using around 62,5% of total memory and I'd like to preserve that percentage value after I've added 32 G. My plan is as follows:

  1. Leave current pga_aggregate_target
Tagged:

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