Examine the current value for the following parameters in your database instance: You
issue the following command to increase the value of DB_8K_CACHE_SIZE: 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 the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
D.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
SGA_MAX_SIZE.
A is the correct answer.
Not D
D is the correct answer, DB_8K_CACHE_SIZE (assuming that 8K is not the default block size for buffer cache) and LOG_BUFFER are not part of autotuned memory and the sum of them + sga_size cannot exceed sga_max_size.
Sorry, but you are wrong. ASMM use SGA_TARGET for all pools. And you can increase its value dynamically until SGA_MAX_SIZE.
I have to show my passion for your generosity for people who actually need guidance on the area of interest. Your personal dedication to passing the message up and down had become unbelievably significant and have usually helped somebody like me to attain their goals. Your amazing useful guide indicates so much a person like me and additionally to my peers. Thanks a lot; from everyone of us.
http://www.bastcilkdoptb.com/
A correct
When you increase the size of a manually sized component, extra memory is taken away from one or more automatically sized components.
https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm
Letter D.
Tested.
SQL> show parameter cache
NAME TYPE VALUE
———————————— ———– ——————————
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_big_table_cache_percent_target string 0
db_cache_advice string ON
db_cache_size big integer 0
db_flash_cache_file string
NAME TYPE VALUE
———————————— ———– ——————————
db_flash_cache_size big integer 0
db_keep_cache_size big integer 0
db_recycle_cache_size big integer 0
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
result_cache_max_result integer 5
result_cache_max_size big integer 2176K
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
session_cached_cursors integer 50
SQL> show parameter sga
NAME TYPE VALUE
———————————— ———– ——————————
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 1G
sga_target big integer 420M
unified_audit_sga_queue_size integer 1048576
SQL> alter system set db_8k_cache_size=124M scope=both;
alter system set db_8k_cache_size=124M scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size
SQL> alter system set db_8k_cache_size=124M scope=memory;
alter system set db_8k_cache_size=124M scope=memory
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size
SQL> alter system set db_8k_cache_size=124M;
alter system set db_8k_cache_size=124M
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size
SQL>
Your test is not valid. You see ORA-00380 certainly because db_block_size is 8k.
Do NOT use the corresponding db_nk_cache_size parameter for the standard block size
Find ORA-00380 here:
http://docs.oracle.com/cd/B19306_01/server.102/b14219/e0.htm
I think “A” is correct.
I tested
*.SGA_MAX_SIZE = 1024M
*.SGA_TARGET = 700M
*.DB_16K_CACHE_SIZE = 124M
*.LOG_BUFFER = 209715200
08:09:32 21.02.17|SP002@test|271|SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2858752 bytes
Variable Size 603980032 bytes
Database Buffers 243269632 bytes
Redo Buffers 218828800 bytes
Database mounted.
Database opened.
08:13:12 21.02.17|SP002@test|271|SQL> ALTER SYSTEM SET DB_16K_CACHE_SIZE=140M;
System altered.
Elapsed: 00:00:00.06