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 0

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