View the SPFILE parameter settings in the Exhibit. You issue this command and get errors: SQL startup ORA-00824:cannot setSGAJTARGET or MEMORY_TARGET due to existing internal settings, see alertlog for more information Why did the instance fail to start?

Question

View the SPFILE parameter settings in the Exhibit. You issue this command and get errors: SQL> startup ORA-00824:cannot setSGAJTARGET or MEMORY_TARGET due to existing internal settings, see alertlog for more information Why did the instance fail to start?

Accepted Answer

B. because statistics_level is set to basic

Answer

A. because pga_aggregate_target is not set

Answer

C. because memory_target and memory_max_target cannot be equal

Answer

D. because sga_target and memory_target are both set

View the SPFILE parameter settings in the Exhibit. You issue this command and get errors: SQL> startup ORA-00824:cannot setSGAJTARGET or MEMORY_TARGET due to existing internal settings, see alertlog…

Question

Exhibit

Options

How the community answered

Community Discussion