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.
A.
The PGA_AGGREGATE_TARGET parameter is set to zero.
B.
The STATISTICS_LEVEL parameter is set to BASIC.
C.
Both the SGA_TARGET and MEMORY_TARGET parameters are set.
D.
The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
Explanation:
Example:
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
MEMORY_TARGET
B is correct answer.
B. The STATISTICS_LEVEL parameter is set to BASIC.
B
Its “B”. Should result ORA-00848 that was omitted on question.
B
B
B (Doc ID 461100.1)
B.
In order for AMM to work : statistics_level parameter should be set to TYPICAL (the default) or ALL
B
That could be the finish of this post. Here youll discover some web pages that we believe youll value, just click the links.
please go to the websites we adhere to, including this one particular, as it represents our picks through the web
Every once in a when we decide on blogs that we read. Listed below would be the newest web sites that we pick out
The information talked about within the article are a few of the best obtainable.
Wonderful story, reckoned we could combine a couple of unrelated data, nevertheless truly really worth taking a look, whoa did 1 find out about Mid East has got extra problerms too.
please stop by the web-sites we stick to, including this a single, because it represents our picks through the web
very handful of internet sites that take place to become detailed beneath, from our point of view are undoubtedly well worth checking out
Here are several of the sites we suggest for our visitors
the time to read or visit the subject material or internet sites we have linked to beneath the
we like to honor many other web sites around the internet, even though they arent linked to us, by linking to them. Under are some webpages worth checking out
that is the finish of this write-up. Here youll locate some sites that we assume you will enjoy, just click the hyperlinks over
we came across a cool site that you just may well take pleasure in. Take a look should you want