Exam 1z0-083 topic 1 question 42 discussion

ABF in AMM the instance exchanges memory between the SGA and the instance PGA as needed (B is correct) In ASMM the instance automatically distributes this memory among the various SGA components (JUST SGA) (A is correct, E incorrect) After a restart the instance return to the SGA values before the shutdown (not the initial values) (C incorrect) https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-8F54391B-D42A-4FDA-9D12-E1F81FD113EA F is also correct: For OLTP systems, the PGA memory typically makes up a small fraction of the available memory, leaving most of the remaining memory for the SGA. For DSS systems running large, memory-intensive queries, PGA memory can typically use up to 70% of the available memory. https://docs.oracle.com/database/121/TGDBA/tune_pga.htm#TGDBA472

ABF is the correct answer

ABF correct

i think abf

E is incorrect as the PGA is not a part of SGA. So the Shared Memory Management cannot mess up with PGA.

The correct answer is ACF. The SGA components memory are allocated at instance startup you can set the sga_target and sga_max_size to determine range allocated but distribution within the components is done at instance startup. B is not correct because SGA and PGA are set differently using SGA_TARGET & SGA_MAX_SIZE and PGA is set with PGA_AGGREGATE_TARGET & PGA_AGGREGATE_LIMIT. SGA is a server process memory area while PGA is a user process memory area.

Automatic Memory Management (AMM) is enabled with "MEMORY_TARGET" or/and "MEMORY_MAX_TARGET" init parameters. Dynamic components of Automatic Memory Management (AMM) are: SELECT component, current_size, min_size, max_size FROM v$memory_dynamic_components WHERE current_size != 0; COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE ------------------------------ ------------ ---------- ---------- shared pool 197132288 192937984 197132288 large pool 4194304 4194304 4194304 java pool 41943040 41943040 41943040 SGA Target 318767104 285212672 318767104 DEFAULT buffer cache 71303168 41943040 75497472 PGA Target 104857600 104857600 138412032 6 rows selected. SQL> then I think the correct answer is ABE

abf for me

ABF is correct