ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

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

Exam 1z0-062 topic 1 question 32 discussion

Actual exam question from Oracle's 1z0-062
Question #: 32
Topic #: 1
[All 1z0-062 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Modasser
Highly Voted 4 years, 1 month ago
D is the correct answer ref: https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11203
upvoted 5 times
Ray520
2 years, 10 months 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, 6 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, 6 months ago
have taking the test?
upvoted 2 times
IamGo0ke
3 years, 6 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, 4 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_
2 years, 9 months ago
in my openion B is correct
upvoted 2 times
...
_Cobra_
2 years, 9 months ago
B is correct answer
upvoted 2 times
...
Ray520
2 years, 10 months 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
2 years, 10 months 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, 4 months ago
The answer is B
upvoted 4 times
...
Phoenix22
4 years, 10 months 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
4 years, 11 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 ago
i think B is right
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago