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

发布时间:2014-10-22 19:01:10编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"OCP-1Z0-053-V13.02-209题",主要涉及到OCP-1Z0-053-V13.02-209题方面的内容,对于OCP-1Z0-053-V13.02-209题感兴趣的同学可以参考一下。

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;


上一篇:MFC中如何添右键弹出菜单
下一篇:常用Maven插件介绍

相关文章

相关评论

本站评论功能暂时取消,后续此功能例行通知。

一、不得利用本站危害国家安全、泄露国家秘密,不得侵犯国家社会集体的和公民的合法权益,不得利用本站制作、复制和传播不法有害信息!

二、互相尊重,对自己的言论和行为负责。

好贷网好贷款