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

SQL性能分析器工作负载捕获

最新推荐文章于 2019-08-10 11:59:50 发布

原创最新推荐文章于 2019-08-10 11:59:50 发布 · 9.3k 阅读

0 ·

CC 4.0 BY-SA版权

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

796 篇文章

订阅专栏

本文介绍使用SQL性能分析器分析SQL工作负载时，创建SQL调优集作为工作负载捕获的一部分所涉及的过程及收集的信息。主要包括SQL文本、执行上下文及执行频率等内容。

42.You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning

Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)

A. the SQL text

B. the execution plan

C. the execution context

D. the execution frequency

E. the system change number (SCN)

Answer: ACD

答案解析：

参考：http://www.oracle.com/technetwork/cn/articles/o69ocp-099954.html

You plan to use SQL Performance Analyzer to analyze a SQL workload, and you’ve created a SQL tuning set as a part of the workload capture. What information is captured as part of this process?

A. The SQL text
B. The execution context
C. The execution frequency
D. The performance statistics

The correct answers are A, B, and C. While creating the SQL tuning set, SQL Performance Analyzer captures the SQL text, the execution context, and the number of times the statement is executed. SQL Performance Analyzer then uses that information to analyze the performance of the SQL statement.