212.Note the following parameters settings in your database:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issued the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
What would happen?
A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B. It will be successful only if the memory is available from the auto tuned components
C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
SGA_TARGET
D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within
SGA_MAX_SIZE
Answer: D
存疑:SGA_MAX_SIZE 应是SGA_TARGET 的上限
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issued the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
What would happen?
A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B. It will be successful only if the memory is available from the auto tuned components
C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
SGA_TARGET
D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within
SGA_MAX_SIZE
Answer: D
存疑:SGA_MAX_SIZE 应是SGA_TARGET 的上限
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 1G
sga_target big integer 704M
SQL> alter system set db_16k_cache_size=200m;
系统已更改。
SQL> alter system set db_16k_cache_size=400m;
系统已更改。
SQL> alter system set db_16k_cache_size=500m;
系统已更改。
SQL>