What would you do to increase the interval of statistics collection for these tables so that the statistics collection jobs spend less time during the automatic maintenance task?

You have the automatic optimizer statistics gathering enabled for a 24×7 database as part of the
automatic maintenance task. You observed that a few tables are being updated regularly, but not
being queried often. However statistics are being gathered for these tables automatically and
regularly, thereby affecting the database performance.
What would you do to increase the interval of statistics collection for these tables so that the
statistics collection jobs spend less time during the automatic maintenance task?

You have the automatic optimizer statistics gathering enabled for a 24×7 database as part of the
automatic maintenance task. You observed that a few tables are being updated regularly, but not
being queried often. However statistics are being gathered for these tables automatically and
regularly, thereby affecting the database performance.
What would you do to increase the interval of statistics collection for these tables so that the
statistics collection jobs spend less time during the automatic maintenance task?

A.
Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

B.
Increase the value of the STALE_PERCENT preference for these tables.

C.
Mark those associated indexes that are less frequently used as invisible.

D.
Increase the value of the ESTIMATE_PERCENT preference for these tables



Leave a Reply 1

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


L. Zhu

L. Zhu

STALE_PERCENT default is 10. change this to reduce the frequency of stats collection

B is correct