You are hired by ABC Pvt Ltd., and assigned the task of managing one of its development databases. The company has recently upgraded this database to Oracle Database 11g from Oracle Database 10g.
You noticed that SGA is undersized as shown in Exhibit 1.
To investigate further, you checked the related parameters as shown in Exhibit 2.
You executed the following command to solve the problem:
ALTER SYSTEM SET MEMORY_TARGET=800M;
What would happen?
A.
The implementation of AMM fails because the MEMORY_MAX_TARGET parameter is not set.
B.
It implements AMM by setting MEMORY_TARGET and
MEMORY_MAX_TARGET parameters to 800M.
C.
It implements Automatic Memory Management (AMM) by setting MEMORY_TARGET to 768M and the MEMORY_MAX_TARGET parameter to 800M.
D.
The implementation of AMM fails because the MEMORY_TARGET parameter cannot be set to a value less than the sum of the current PGA_AGGRAGATE_TARGET and SGA_MAX_SIZE values.
i think option b is correct – if you do not set memory_max_target oracle will set it to the same value as memory_target… just tried with my test machine (oracle 11.2.0.3)
A is correct answer
BD
I agree with Benjamin, B is the correct answer.
A is incorrect, if memory_max_target is not set when setting memory_target, Oracle will default to value of memory_target:
https://oracle-base.com/articles/11g/automatic-memory-management-11gr1
C is incorrect, as it goes completely contrary to the statement you issued.
D is incorrect as the memory_target is greater than or equal to the size of the PGA and SGA targets added together. These two values will now be taken as the minimum for each area (so PGA and SGA will both be sized minimum 384MB each) with the remaining 32MB dynamically allocated by Oracle as it decides.
So B is the correct answer.