Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 1 question 32 discussion

Actual exam question from Oracle's 1z0-062

Question #: 32
Topic #: 1

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?

A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
B. It succeeds only if memory is available from the autotuned components if SGA.
C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Show Suggested Answer

Suggested Answer: D 🗳️
* The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and it can also be reduced.
* Example:
For example, suppose you have an environment with the following configuration:

SGA_MAX_SIZE = 1024M -

SGA_TARGET = 512M -

DB_8K_CACHE_SIZE = 128M -
In this example, the value of SGA_TARGET can be resized up to 1024M and can also be reduced until one or more of the automatically sized components reaches its minimum size. The exact value depends on environmental factors such as the number of CPUs on the system. However, the value of
DB_8K_CACHE_SIZE remains fixed at all times at 128M
* DB_8K_CACHE_SIZE

Size of cache for 8K buffers -
* For example, consider this configuration:

SGA_TARGET = 512M -

DB_8K_CACHE_SIZE = 128M -
In this example, increasing DB_8K_CACHE_SIZE by 16 M to 144M means that the 16M is taken away from the automatically sized components. Likewise, reducing DB_8K_CACHE_SIZE by 16M to 112M means that the 16M is given to the automatically sized components.

by verratti at Feb. 12, 2020, 8:55 a.m.

Comments

Submit Cancel

Modasser

Highly Voted 4 years, 4 months ago

D is the correct answer ref: https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11203

upvoted 5 times

Ray520

3 years, 1 month ago

Please can you explain why it's D? After reading the document and trying to understand it seems B is correct.

upvoted 1 times

...

IamGo0ke

3 years, 10 months ago

Answer is B ref: https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11218 Increasing DB_8K_CACHE_SIZE by 16 M to 144M means that the 16M is taken away from the automatically sized components. Likewise, reducing DB_8K_CACHE_SIZE by 16M to 112M means that the 16M is given to the automatically sized components.

upvoted 7 times

soniat

3 years, 9 months ago

have taking the test?

upvoted 2 times

IamGo0ke

3 years, 9 months ago

Yes, I did today and I passed. Quite a number of the questions here came out with other few new questions. The set of questions here was a great help.

upvoted 2 times

...

luizyto

Most Recent 2 years, 8 months ago

Answer is B, we always configure sga_target =sga_max_size and sometimes we configure cache_size to n_value without reducing the sga_target, so the static value for a components of sga is taken from sga_target. It does not make sense to sum sga_target+cache_size. It is sga_target-cache_size=memory available for automatic components of sga not defined.

upvoted 1 times

...

_Cobra_

3 years ago

in my openion B is correct

upvoted 2 times

...

_Cobra_

3 years ago

B is correct answer

upvoted 2 times

...

Ray520

3 years, 1 month ago

Log_buffer and db_nk_cache_size are manually sized sga parameters and take their value from sga_max_size and not sga_target. So log_buffer and db_8k_cache_size in this example cannot exceed 324M (sga_max_size - sga_target = 324M in this example). Hence the increase to 140M will fail, so D is indeed correct. Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11203

upvoted 2 times

...

Ray520

3 years, 1 month ago

Log_buffer and db_nk_cache_size are manually sized sga parameters and take their value from sga_max_size and not sga_target. So log_buffer and db_8k_cache_size in this example cannot exceed 340M (sga_max_size - sga_target = 340M in this example). Hence the increase to 140M will fail, so D is indeed correct. Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11203

upvoted 1 times

...

Aleksandar

3 years, 8 months ago

The answer is B

upvoted 4 times

...

Phoenix22

5 years, 1 month ago

Answer is surely B. As D says … It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE. while having value of 124M , and willing to increase it to 144M , which is 20MB extra . For this SGA size it’s with granule of 4MB. So it should work fine under SGA_TARGET. SGA_MAX_SIZE is set to 1024M while SGA_TARGET=700M, so talking about SMS is not relevant here.

upvoted 3 times

...

hggz

5 years, 2 months ago

B is correct. Ref: https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11202

upvoted 3 times

...

verratti

5 years, 3 months ago

i think B is right

upvoted 3 times

...