As a DBA configuring a new instance, you want to run a representative workload on the instance
and examine the relevant statistics to see whether the cache is underconfigured or
over configured.
Given below is a list of the initialization parameters that would affect the statistics
collection and advisories.
1. STATISTICS_LEVEL set to BASIC
2. STATISTICS_LEVEL set to TYPICAL
3. DB_CACHE_ADVICE set to ON
4. TIMED_STATISTICS set to TRUE
Which of the above initialization parameters’ values must be set explicitly to get the relevant
statistics with minimal impact on the overall database performance?
A.
only 2
B.
2 and 3
C.
1, 3, and 4
D.
2, 3, and 4
Once statistics_level=typical (or all), timed_statistics and db_cache_advice are turned on
So A is right