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 11

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


Lei

Lei

correct answer is B

Kiran

Kiran

Answer is B.

SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings
ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET
SQL>

Tri

Tri

Thanks Kiran!

Tri

Tri

Tested B corrrect.

puntano

puntano

Thank you

IS IT CORRECT?

IS IT CORRECT?

thanks

RNW

RNW

I wonder who is this “seenagape”
I would like to thank him for the questions here, but I’d like to know the dismal source of the answers!