Is AMM being used ?

Yockee

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

JohnWatson2

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

Yockee

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