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…

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 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 In addition to setting SGA_TARGET to a…

Managing the Database Instance

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

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

(30 responses)

A
70% (21)
B
10% (3)
C
17% (5)
D
3% (1)

Explanation

Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization / The 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 * 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 * Table, Automatically Sized SGA Components and Corresponding Parameters

Topics

#Automatic Shared Memory Management (ASMM)#SGA Components#Initialization Parameters

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice