Home » Oracle » 1z0-062 v.2 » Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?
Examine the following parameters for a database instance:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=0
SGA_TARGET=0
PGA_AGGREGATE_TARGET=500m
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?
A. LOG_BUFFER
B. SORT_AREA_SIZE
C. JAVA_POOL_SIZE
D. STREAMS_POOL_SIZE
E. DB_16K_CACHE_SZIE
F. DB_KEEP_CACHE_SIZE
Correct Answer: AEF
Explanation/Reference:
Manually Sized SGA Components that Use SGA_TARGET Space
SGA Component, Initialization Parameter
/ The log buffer
LOG_BUFFER
/ The keep and recycle buffer caches
DB_KEEP_CACHE_SIZE
DB_RECYCLE_CACHE_SIZE
/ Nonstandard block size buffer caches
DB_nK_CACHE_SIZE
Note:
*In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable fullautomatic tuning of the automatically sized SGA components.
*Table, Automatically Sized SGA Components and Corresponding Parameters
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
