Which is the best solution that you would recommend?

You work for ABC Pvt Ltd. The company has recently upgraded one of its development databases
to Oracle Database 11g from Oracle Database 10g.
You noticed that the System Global Area (SGA) is undersized as shown in the Exhibit.
To investigate further, you checked the related parameters as shown below:
SQL> show parameter sga_max_size
NAME TYPE VALUE
—————————— ————— —————–
sga_max_size big integer 500M
SQL> show parameter target
NAME TYPE VALUE
—————————— ————— ——————
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
pga_aggregate_target big integer 384M
sga_target big integer 384M
Which is the best solution that you would recommend?

A.
Increase the value of the SGA_MAX_SIZE parameter.

B.
Set MEMORY_MAX_TARGET and MEMORY_TARGET parameters.

C.
Reduce the value of the PGA_AGGREGATE_TARGET parameter.

D.
Increase the value of both SGA_TARGET and PGA_AGGREGATE_TARGET parameters.

E.
Diagnose further to identify which component in SGA is undersized and then resize it.