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 overconfigured.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
When STATISTICS_LEVEL set to TYPICAL, DB_CACHE_ADVICE defaults to ON and TIMED_STATISTICS defaults to TRUE.
So A is correct.