OCP-1Z0-053-V12.02-298题

最新推荐文章于 2019-08-12 10:40:32 发布

原创最新推荐文章于 2019-08-12 10:40:32 发布 · 8.4k 阅读

0 ·

CC 4.0 BY-SA版权

OCP11g解析同时被 2 个专栏收录

870 篇文章

订阅专栏

OCP-1Z0-053

796 篇文章

订阅专栏

本文探讨了在SQL调优过程中，当SQL Tuning Advisor遇到具有陈旧统计信息的现有SQL配置文件时，优化器如何处理这种情况。文章解释了优化器会将这些统计信息提供给GATHER_STATS_JOB，以便后续收集最新的统计数据。

298.While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement

that has stale statistics available.

What would the optimizer do in this situation?

A. It updates the existing SQL profiles with current statistics.

B. It makes the statistics information available to GATHER_STATS_JOB.

C. It initiates the statistics collection process by running GATHER_STATS_JOB.

D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.

Answer: B

答案解析：

Actions represent the jobs that are performed by a module. For example, the DBMS_SCHEDULER module can run the GATHER_STATS_JOB action to gather statistics on all database objects. If a single action is using the majority of the wait time, then you should investigate it.