Free Preparation Discussions
MENU
Oracle Exam 1Z0-084 Topic 1 Question 20 Discussion
Topic #: 1
SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARGT is not set.
Which two statements are true?
A)
B)
C)
D)
E)
F)
G)
When MEMORY_TARGET is set to a nonzero value, Oracle automatically manages the memory allocation between the System Global Area (SGA) and the Program Global Area (PGA). If MEMORY_MAX_TARGET is not explicitly set, Oracle will behave in the following manner:
MEMORY_MAX_TARGET will default to the value of MEMORY_TARGET, assuming the platform allows for the value of MEMORY_TARGET to be increased dynamically. This means that MEMORY_TARGET represents both the initial allocation and the maximum limit for the dynamically managed memory unless MEMORY_MAX_TARGET is specified differently.
If MEMORY_TARGET is set to a value that is less than the sum of the current values of SGA_TARGET and PGA_AGGREGATE_TARGET, Oracle will use the higher sum as the default value for MEMORY_MAX_TARGET to ensure that there is adequate memory for both areas. The database instance will not start if MEMORY_TARGET is not sufficient to accommodate the combined SGA and PGA requirements.
Reference
Oracle Database Administrator's Guide 19c: Automatic Memory Management
Oracle Database Performance Tuning Guide 19c: Using Automatic Memory Management
Meaghan
2 months agoLonna
26 days agoJade
1 months agoTequila
1 months agoMelissa
2 months agoNicolette
2 months agoPete
1 months agoTwila
1 months agoMinna
1 months agoEileen
3 months agoPura
3 months agoStanton
2 months agoDolores
2 months agoYun
2 months agoMa
2 months agoLisha
3 months agoNina
2 months agoKeena
2 months agoMitzie
3 months ago