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)
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?
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.