Which two statements are correct in this scenario?

You enabled Automatic Shared Memory Management. The initialization parameters are set
as shown below:
SGA_TARGET = 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)

You enabled Automatic Shared Memory Management. The initialization parameters are set
as shown below:
SGA_TARGET = 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)

A.
A total of 14 GB memory will be allocated to the automatically tuned memory
components.

B.
Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory
allocated to shared pool from 3 GB to 2 GB.

C.
The value for SGA_TARGET can be increased up to a maximum of 14 GB.

D.
A maximum of 3 GB can be allocated to shared pool.

E.
Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory
allocated to autotuned parameters.

F.
Increasing the value for SGA_TARGET will automatically increase the memory allocated
for STREAMS_POOL_SIZE.



Leave a Reply 0

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