OCP-043 DB_nK_CACHE_SIZE

DB_nK_CACHE_SIZE

PropertyDescriptionParameter typeBig integerSyntaxDB_[2 | 4 | 8 | 16 | 32]K_CACHE_SIZE = integer [K | M | G]Default value0 (additional block size caches are not configured by default)ModifiableALTER SYSTEMRange of valuesMinimum: 0 (values greater than zero are automatically modified to be either the user-specified-size rounded up to granule size or 4MB * number of CPUs * granule size, whichever is greater)

Maximum: operating system-dependent

BasicNo

DB_nK_CACHE_SIZE (where n = 2, 4, 8, 16, 32) specifies the size of the cache for the nK buffers. You can set this parameter only when DB_BLOCK_SIZE has a value other than nK. For example, if DB_BLOCK_SIZE=4096, then it is illegal to specify the parameter DB_4K_CACHE_SIZE (because the size for the 4 KB block cache is already specified by DB_CACHE_SIZE).

Do not set this parameter to zero if there are any online tablespaces with an nK block size.

Operating system-specific block size restrictions apply. For example, you cannot set DB_32K_CACHE_SIZE if the operating system's maximum block size is less than 32 KB. Also, you cannot set DB_2K_CACHE_SIZE if the minimum block size is greater than 2 KB.

77. You have set some of the initialization parameters as:

DB_BLOCK_SIZE = 8KB
SGA_MAX_SIZE = 2GB
SGA_TARGET = 0
SHARED_POOL_SIZE = 120MB

DB_CACHE_SIZE = 896MB
STREAM_POOL_SIZE = 0
LARGE_POOL_SIZE = 110MB
Which two statements are correct? (Choose two.)
A.You cannot set a value for the DB_8K_CACHE_SIZE parameter.
B.The memory used by Streams will be allocated from the shared pool.
C.If you increase the size of large pool to 120 MB, then the memory allocated to shared pool will be
reduced to 110 MB.
D.If an application attempts to allocate more than 120 MB from the shared pool, and free space is
available in the buffer pool, then the free space from the buffer pool is allocated to the shared pool.

Answer: AB