Forum Stats

  • 3,874,651 Users
  • 2,266,759 Discussions
  • 7,911,926 Comments

Discussions

Is AMM being used ?

Hi,

I have just finished upgrading 11g to 19c.

When I do query "SELECT name,value,display_value,isdefault,isbasic FROM V$PARAMETER WHERE name IN ('memory_target', 'sga_target', 'pga_aggregate_target');", the result is as follows :

SGA_TARGET = 0

MEMORY_TARGET = 0

PGA_AGGREGATE_TARGET = 30 GB.

What can I tell about these memory values ?

Is this telling me that AMM is being used ? What I know, for manual management, all values must be 0.

thanks

Answers

  • JohnWatson2
    JohnWatson2 Member Posts: 4,515 Silver Crown

    That result will be because your session is in a pluggable container, not the root container.

  • Yockee
    Yockee Member Posts: 24 Green Ribbon
    edited Jun 28, 2022 3:29AM

    Hi John,

    Are those values shown above not enough (or may be even wrong) whether AMM is being used or not ? I don't find those type of combination so I can not determine if AMM is being used or not.

    So, what do I have to do to see all those memories and determine whether AMM is being used or not ? Do i have to login to root container ?


    thanks