Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit.

SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET due to existing internal settings, see alertlog for more information
Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit.

SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET due to existing internal settings, see alertlog for more information
Why did the instance fail to start?

A.
because pga_aggregate_target is not set

B.
because statistics_level is set to basic

C.
because memory_target and memory_max_target cannot be equal

D.
because sga_target and memory_target are both set



Leave a Reply 0

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