View the SPFILE parameter settings in the Exhibit. You issue this command and get errors: SQL> startup ORA-00824:cannot set SGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog…

The correct answer is B. because statistics_level is set to basic. 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

New Features for Performance

Question

View the SPFILE parameter settings in the Exhibit. You issue this command and get errors:

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

Exhibit

Options

Abecause pga_aggregate_target is not set
Bbecause statistics_level is set to basic
Cbecause memory_target and memory_max_target cannot be equal
Dbecause sga_target and memory_target are both set

How the community answered

(43 responses)

A
7% (3)
B
81% (35)
C
9% (4)
D
2% (1)

Explanation

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

Topics

#MEMORY_TARGET#statistics_level BASIC#AMM#SPFILE parameters

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice