Identify the reason for this.

The SALES table in your database undergoes frequent changes. While observing the statistics for
the table in the middle of the day, you find a change since the last observation. But the information
about the statistics collection is not recorded in the DBA_TAB_STATS_HISTORY. Identify the
reason for this.

The SALES table in your database undergoes frequent changes. While observing the statistics for
the table in the middle of the day, you find a change since the last observation. But the information
about the statistics collection is not recorded in the DBA_TAB_STATS_HISTORY. Identify the
reason for this.

A.
The AWR retention time was set to zero.

B.
The STATISTICS_LEVEL parameter was set to BASIC.

C.
Some of the statistics were collected using the ANALYZE command.

D.
There were user-defined statistics that were set by using the
DBMS_STATS.SET_TABLE_STATS procedure.



Leave a Reply 1

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


L. Zhu

L. Zhu

if the stats is collected by analyze, it won’t be recorded in tab_statistics_history

C is correct