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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |