Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:

SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for
moreinformation
Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:

SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for
moreinformation
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 2

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