memory_target big integer 808M
pga_aggregate_target big integer 0
sga_target big integer 0
SQL> SHOW PARAMETER SGA_MAX_SIZE
NAME TYPE VALUE
————————————————————————————————-
sga_max_size big integer 808M
Which statement is correct about the database?
A.
Automatic memory management is disabled because PGA_AGGREGATE_TARGET and
SGA_TARGET are not set.
B.
The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET
and
C.
SGA_TARGET are set.
D.
The database is opened but users cannot perform transactions until
PGA_AGGREGATE_TARGET and SGA_TARGET are set.
E.
Automatic memory management is enabled and, as per the policy, 60% of the memory for
System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be
distributed at startup.