OCP-1Z0-053-V13.02-209题

最新推荐文章于 2021-04-06 16:31:28 发布

原创最新推荐文章于 2021-04-06 16:31:28 发布 · 7.4k 阅读

1 ·

CC 4.0 BY-SA版权

OCP-1Z0-053 专栏收录该内容

796 篇文章

订阅专栏

本文探讨了在Oracle数据库中如何设置会话参数以控制统计信息的收集，并解释了这些统计信息如何被存储及使用。通过具体命令示例展示了如何将新收集的统计信息标记为待处理状态，而非立即作为当前统计信息使用。

209.You executed the following commands:

SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;

SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH','false');

SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the

above session?

A. The statistics are stored in the pending statistics table in the data dictionary.

B. The statistics are treated as the current statistics by the optimizer for all sessions.

C. The statistics are treated as the current statistics by the optimizer for the current sessions only.

D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

Answer: A

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/stats.htm#PFGRF94725

By default, the optimizer uses the published statistics stored in the data dictionary views. If you want the optimizer to use the newly collected pending statistics, then set the initialization parameter OPTIMIZER_USE_PENDING_STATISTICS to TRUE (the default value is FALSE), and run a workload against the table or schema:

ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = TRUE;