Database Administration (MOSC)

MOSC Banner

Memory settings for Oracle

edited Jul 29, 2023 1:24PM in Database Administration (MOSC) 8 commentsAnswered ✓

Hello,

I have 256 G of physical memory and two Oracle 19.20 instances with following setup on Prod:

sga_target=0;

sga_max_size=0

pga_aggregate_target=0

memory_target=168G

memory_max_target=184G

After few days in production I see following parameters there:

NAME                 TYPE    VALUE

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

pga_aggregate_limit         big integer 184G

sga_max_size             big integer 102912M

I assume that pga_aggregate_limit was taken from memory_max_target as I did not set it up.

sga_max_size shows 100 GB so I assume it is set according to current dynamic value. (I set it to 0 during configuration).

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