Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
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
-
That result will be because your session is in a pluggable container, not the root container.
-
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