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
|
Download Printable PDF. VALID exam to help you PASS. |
 |