You set the following parameters in the parameter file and restarted the database: Which two statements are true about these parameters after the database instance is restarted? (Choose two.)
A.
The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
B.
The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
C.
The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
D.
The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.
The MEMORY_MAX_TARGET is static parameter. And any change to this parameter will need a database bounce. And it is the MAX allowable Memory to be used by the SGA is AMM is enabled. So if you are setting MEMORY_TARGET=500M and MEMORY_MAX_TARGET=0 , The instance will not come up because MEMORY_TARGET is greater than MEMORY_MAX_TARGET.
Bottom line :- MEMORY_MAX_TARGET will not be changed automatically.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Avez_DBA
1 year, 7 months ago