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

最新推荐文章于 2016-11-27 14:52:45 发布

原创最新推荐文章于 2016-11-27 14:52:45 发布 · 6.3k 阅读

2 ·

CC 4.0 BY-SA版权

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

796 篇文章

订阅专栏

本文介绍在创建SQL调优集时如何通过筛选操作和值来减少SQL集合的大小，以提高调优效率。通过应用过滤器，可以定向地减少SQL顾问、SQL访问顾问和SQL性能分析器在工作负载源中推荐的SQL语句范围，从而可能获得更精准的建议，并显著降低使用SQL调优集作为工作负载源时的处理时间。

404.When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the

SQL set by selecting specific operators and values?

A. Filter versions

B. Filter loads

C. Filter tasks

D. Filter options

Answer: D

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e10822/tdppt_sqltune.htm#TDPPT157

Creating a SQL Tuning Set: Filter Options

After the load method is selected, you can apply filters to reduce the scope of the SQL statements found in the SQL tuning set. While using filters is optional, it can be very beneficial due to the following:

Using filters directs the various advisors that use the SQL tuning set as a workload source, such as SQL Tuning Advisor, SQL Access Advisor, and SQL Performance Analyzer, to make recommendations based on a specific subset of SQL statements, which may lead to better recommendations.
Using filters removes extraneous SQL statements from the SQL tuning set, which may greatly reduce processing time when it is used as a workload source for the various advisors.

Tip:

Before you can specify the filter options for the SQL tuning set, do the following:

Create a SQL tuning set and specify the initial options, as described in "Creating a SQL Tuning Set: Options"
Select the load method, as described in "Creating a SQL Tuning Set: Load Method"

To specify filter options for a SQL tuning set:

On the Create SQL Tuning Set: Filter Options page, specify the values of filter conditions that you want use in the search in the Value column, and an operator or a condition in the Operator column.

Only the SQL statements that meet all of the specified filter conditions will be added to the SQL tuning set. Unspecified filter values will not be included as filter conditions in the search.

By default, the following filter conditions are displayed:
- Parsing Schema Name
- SQL Text
- SQL ID
- Elapsed Time (sec)
To add filter conditions, under Filter Conditions, select the filter condition you want to add and click Add a Filter or Column.

After the desired filter conditions have been added, specify their values in the Value column, and an operator or a condition in the Operator column.
To remove any unused filter conditions, click the icon in the Remove column for the corresponding filter condition you want to remove.
Click Next.

The Create SQL Tuning Set: Schedule page appears.
Proceed to the next step, as described in "Creating a SQL Tuning Set: Schedule".