Examine this extract from the show parameters command:
How are System Global Area (SGA) and Program Global Area (PGA) memory managed by an instance using these parameter settings?
A.
SGA and PGA memory are manually managed
B.
SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management
C.
SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed
D.
SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management
E.
SGA and PGA memory are managed by using Automatic Memory Management (AMM)
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
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".
This section is not available anymore. Please use the main Exam Page.1z0-083 Exam Questions
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.
_gio_
11 months, 3 weeks agoScottL
1 year, 2 months agovkra
1 year, 4 months agovkra
1 year, 4 months agofrankkk
1 year, 5 months agohilaire
1 year, 6 months agoilputto
1 year, 6 months ago