Note the following parameters settings in your database:
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
Explanation:
This is an actually mathematic question.
I don’t think so, DB_8K_CACHE_SIZE and LOG_BUFFER size includes within SGA_TARGET.
Correct answer should be option A, that it can’t be changed dynamically.
Willgax is incorrect in all 3 of his statements here.
Only the default buffer cache is held in SGA_TARGET (perhaps the question could be clearer that 8k is not the default, but I think it is reasonable to imply this). Any non-standard size DB buffer caches are held in the SGA but outside of SGA_TARGET.
Also the LOG_BUFFER is held in the SGA but outside SGA_TARGET. See:
http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams193.htm#REFRN10256
Also, non-standard buffer cache sizes can be changed dynamically.
From my own DB:
select name, issys_modifiable
from v$parameter
where name = ‘db_8k_cache_size’
“NAME” “ISSYS_MODIFIABLE”
db_8k_cache_size IMMEDIATE
So correct answer is as marked and is D
The correct answer is B.
Willgax, db_8k_cache_size is a dynamic init.
Rodge you should read your own link. It says …
The memory allocated to these pools (incl db_8k_cache_size) is deducted from the total available for SGA_TARGET when Automatic Shared Memory Management computes the values of the automatically tuned memory pools.
I suggest reading the following
http://oracle.su/docs/11g/server.112/e10821/memory.htm#i58728
Even better, have a look at ….
http://www.aiotestking.com/oracle/which-statement-is-true-95/
The answer is B, Eamon already explained why. Thanks!