What information is captured as part of this process?

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
The SQL text
The Automatic Memory Manager (AMM)

B.
the execution plan
The execution context
The SQL Tuning Advisor

C.
the execution context
The execution frequency
The Segment Advisor

D.
the execution frequency
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.
QUESTION 495
You have a very large table that your users access frequently. Which of the following
advisors will recommend any indexes to improve the performance of queries against this
table?
The SQL Access Advisor

E.
the system change number (SCN)

A.
the SQL text
The SQL text
The Automatic Memory Manager (AMM)

B.
the execution plan
The execution context
The SQL Tuning Advisor

C.
the execution context
The execution frequency
The Segment Advisor

D.
the execution frequency
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.
QUESTION 495
You have a very large table that your users access frequently. Which of the following
advisors will recommend any indexes to improve the performance of queries against this
table?
The SQL Access Advisor

A.
the SQL text
The SQL text
The Automatic Memory Manager (AMM)

B.
the execution plan
The execution context
The SQL Tuning Advisor

C.
the execution context
The execution frequency
The Segment Advisor

D.
the execution frequency
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.
QUESTION 495
You have a very large table that your users access frequently. Which of the following
advisors will recommend any indexes to improve the performance of queries against this
table?
The SQL Access Advisor

Explanation:
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?

The SQL Access Advisor analyzes all SQL running during a given time period and
recommends indexes and materialized views to improve the overall performance of the
database.
A is incorrect because there is no such advisor as the Automatic Memory Manager.
B is incorrect because the SQL Tuning Advisor looks only at a single SQL statement and
provides recommendations.
C is incorrect because the Segment Advisor recommends segment shrink when table and
index segments are heavily fragmented.