Which two statements are true regarding the SGA_TARGET initialization parameter?

Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

Question:

Which two statements are true regarding the SGA_TARGET initialization parameter?

Options:

It can be increased up to the value of the SGA_MAX_SIZE parameter.

Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.

Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components.

Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.

Correct Answer

The Correct Answer for this Question is

It can be increased up to the value of the SGA_MAX_SIZE parameter.
Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.

Leave a Comment