Which of the above initialization parameters’ values must be set explicitly to get the relevant statistics

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?

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



Leave a Reply 1

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


Rodge

Rodge

When STATISTICS_LEVEL set to TYPICAL, DB_CACHE_ADVICE defaults to ON and TIMED_STATISTICS defaults to TRUE.

So A is correct.