1Z0-060 · Question #20
Examine the current value for the following parameters in your database instance: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issue the following command to…
The correct answer is B. It succeeds only if memory is available from the autotuned components if SGA. It will be successful only if the memory is available from the auto tuned components although it could also fail if an increase in DB_8K_CACHE_SIZE cannot be accommodated within
Question
Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; Which statement is true?
Options
- AIt fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
- BIt succeeds only if memory is available from the autotuned components if SGA.
- CIt fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
- DIt fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
How the community answered
(26 responses)- A12% (3)
- B62% (16)
- C19% (5)
- D8% (2)
Explanation
It will be successful only if the memory is available from the auto tuned components although it could also fail if an increase in DB_8K_CACHE_SIZE cannot be accommodated within
Topics
Community Discussion
No community discussion yet for this question.