What would happen?

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?

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.



Leave a Reply 0

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