How would you ensure that the System Global Area (SGA) is optimally shared among all its subcomponents?
A.
Set the size of each subcomponent manually.
B.
Use the memory advisor to help you determine the settings for each of the individual components.
C.
Enable Automatic Shared Memory Management in the database by setting the value of the SGA_TARGET parameter.
D.
Enable Automatic Shared Memory Management in the database by setting the SGA_MAX_SIZE in the initialization parameter file.