Which statement is true?

Examine the current value for the following parameters in your database instance: Which
statement is true?

Examine the current value for the following parameters in your database instance: Which
statement is true?

A.
It succeeds only if memory is available from the autotuned components if SGA.

B.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
SGA_TARGET.

C.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
SGA_MAX_SIZE.

D.
It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

Show Hint

Leave a Reply 3

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

sky

sky

confused but i thinks A.

https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams043.htm#REFRN10027

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.

Reply