Exam 1z0-083 topic 1 question 164 discussion

I agree with E: if you set memory target you use AMM. PGA_AGGREGATE_LIMIT of 2GB is hard limit for PGA that can't be reached because of 800MB memory max target

E - see vkra

https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-0F348EAB-9970-4207-8EF3-0F58B64E959A : The simplest way to manage instance memory is to allow the Oracle Database instance to automatically manage and tune it for you. To do so (on most platforms), you set only a target memory size initialization parameter (MEMORY_TARGET) and optionally a maximum memory size initialization parameter (MEMORY_MAX_TARGET). https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-0E201F66-D280-472A-AD80-20AB8F7E9C01 : You can omit the statements that set the SGA_TARGET and PGA_AGGREGATE_TARGET parameter values to zero and leave either or both of the values as positive numbers. In this case, the values act as minimum values for the sizes of the SGA or instance PGA. In addition, you can use the PGA_AGGREGATE_LIMIT initialization parameter to set an instance-wide hard limit for PGA memory. You can set PGA_AGGREGATE_LIMIT whether or not you use automatic memory management. See "Using Automatic PGA Memory Management".

E correct

E correct

correct