ITPub博客

首页 > 数据库 > Oracle > Oracle 11G OCP 1Z0-053 487

Oracle 11G OCP 1Z0-053 487

原创 Oracle 作者:LuiseDalian 时间:2014-10-20 20:14:57 0 删除 编辑
(487)When executing a SQL workload,you choose to generate execution plans only,without collecting execution statistics.

Which two statements describe the implications of this?(Choose two.)

A. It produces less accurate results of the comparison analysis.

B. It automatically calls the SQL Tuning Advisor for recommendations.

C. It shortens the time of execution and reduces the impact on system resources.

D. Only the changes in the execution plan,and not performance regression,are detected.

答案:(A、C)

解析:

只产生执行计划可以更少的去计算结果,同时减少对系统资源的影响

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1305129/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6043058