分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
41. You have recently collected statistics on certain objects of a schema in your database. But you
observe suboptimal execution plans for the queries on these objects after two days of statistics collection.
The optimizer statistics retention period is set to its default value.
Which action would help to use the previous set of statistics on the objects?
A.Restore statistics from statistics history.
B.Reduce the optimizer statistics retention period by 2 days.
C.Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.
D.Reduce the Automatic Workload Repository (AWR) retention period by 2 days.
Answer: ARESTORE_TABLE_STATS Procedure
This procedure restores statistics of a table as of a specified timestamp (as_of_timestamp
). The procedure will restore statistics of associated indexes and columns as well. If the table statistics were locked at the specified timestamp the procedure will lock the statistics. The procedure will not restore user defined statistics.