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
correct answer is B
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>
Thanks Kiran!
Tested B corrrect.
Thank you
thanks
B
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!
B
http://oraclesniplets.tumblr.com/post/2061083576/my-oracle-support-knowledge-browser-4611001
B
B