Database Memory & 4030/4031 (MOSC)

MOSC Banner

Would like explanation on Oracle's Automatic Memory Management choices

edited Oct 10, 2018 10:19AM in Database Memory & 4030/4031 (MOSC) 6 commentsAnswered
Hi,
I don't understand why Oracle automatic memory management is giving a huge chunk of memory (50G) to the PGA. I recently started using automated memory management, going from having init parameters:

  sga_target = 32G
  pga_aggregate_target = 400M
  memory_target_max_target = 0
  memory_target = 0

to:

  sga_target = 0
  pga_aggregate_target = 0
  memory_target_max_target = 82G
  memory_target = 82G

After running for about a day I have this:

SQL> select * from V$MEMORY_DYNAMIC_COMPONENTS where current_size != 0;

COMPONENT                                                        CURRENT_SIZE   MIN_SIZE   MAX_SIZE USER_SPECIFIED_SIZE OPER_COUNT LAST_OPER_TYP LAST_OPER LAST_OPER GRANULE_SIZE
---------------------------------------------------------------- ------------ ---------- ---------- ------------------- ---------- ------------- --------- --------- ------------

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