Prev Question
Next Question

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

Explanation:
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 full automatic tuning of the automatically sized SGA components.
* Table, Automatically Sized SGA Components and Corresponding Parameters

5a4b98c366ce9 - Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *