Which two statements are true regarding the SGA_TARGET initialization parameter?

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

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

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

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

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

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



Leave a Reply 0

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