Which of the above initialization parameters’ values must be set explicitly to get the relevant statistics with minimal impact on the overall database performance?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

Once statistics_level=typical (or all), timed_statistics and db_cache_advice are turned on

So A is right