Examine the following parameters for a database instance: Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

The correct answer is A. LOG_BUFFER E. DB_16K_CACHE_SZIE F. DB_KEEP_CACHE_SIZE. Manually Sized SGA Components that Use SGA_TARGET Space SGA Component,Initialization /The keep and recycle buffer caches DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE /Nonstandard block size buffer caches DB_nK_CACHE_SIZE In addition to setting SGA_TARGET to a nonzero value, you…

New Features for Performance

Question

Examine the following parameters for a database instance:

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

Exhibit

Options

ALOG_BUFFER
BSORT_AREA_SIZE
CJAVA_POOL_SIZE
DSTREAMS_POOL_SIZE
EDB_16K_CACHE_SZIE
FDB_KEEP_CACHE_SIZE

How the community answered

(44 responses)

A
75% (33)
B
2% (1)
C
16% (7)
D
7% (3)

Explanation

Manually Sized SGA Components that Use SGA_TARGET Space SGA Component,Initialization /The keep and recycle buffer caches DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE /Nonstandard block size buffer caches DB_nK_CACHE_SIZE * In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed inthe table belowto enable full automatic tuning of the automatically sized SGA * Table,Automatically Sized SGA Components and Corresponding Parameters

Topics

#ASMM#SGA parameters#memory management#LOG_BUFFER

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice