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)?

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



Leave a Reply 5

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


Piotr

Piotr

The manually tuned ASMM initialization parameters are DB_KEEP_CACHE_
SIZE, DB_RECYCLE_CACHE_SIZE, DB_nK_CACHE_SIZE, and LOG_BUFFER.

A, E, F

Stackerpm

Stackerpm

Sort_area_size is in the pga. Does this count in asmm? Should the answer be abde?

Stackerpm

Stackerpm

Sorry I meant abef?