1Z0-062 · Question #21
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL >…
The correct answer is B. The STATISTICS_LEVEL parameter is set to BASIC. SQL> startup force 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
Question
To implement Automatic Management (AMM), you set the following parameters:
When you try to start the database instance with these parameter settings, you receive the following error message:
SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.
Exhibit
Options
- AThe PGA_AGGREGATE_TARGET parameter is set to zero.
- BThe STATISTICS_LEVEL parameter is set to BASIC.
- CBoth the SGA_TARGET and MEMORY_TARGET parameters are set.
- DThe SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
How the community answered
(64 responses)- A9% (6)
- B72% (46)
- C14% (9)
- D5% (3)
Explanation
SQL> startup force 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
Community Discussion
No community discussion yet for this question.