Oracle 11G OCP 1Z0-052 40

（40）You have statistics collected for some selected tables.

Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time.

How would you achieve this?

A. Lock statistics for the tables.

B. Change STALE_PERCENT to zero for the tables.

C.Set the TIMED_STATISTICS parameter to TRUE.

D.Set the STATISTICS_LEVEL parameter to BASIC.

E.Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

答案：（A）

解析：

A. 可以使用DBMS_STATS.LOCK_TABLE_STATS過程

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1178452/，如需轉載，請註明出處，否則將追究法律責任。