which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Jake from SF

Jake from SF

D is correct:

https://docs.oracle.com/cd/B19306_01/server.102/b28051/tdppt_sqltune.htm#CHDIGBJH

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 into 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.

The available filter conditions include:

Plan hash value
Module
Action
CPU time (sec)
Buffer gets
Disk reads
Disk writes
Rows processed
Fetches
Executions
End of fetch count
Command type
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