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 Do- the execution frequency
D.
the system change number (SCN)
Answer D is wrong. The right answers are A, C and D.
Oracle says:
“A SQL Tuning Set includes the following:
A set of SQL statements
Associated execution context, such as user schema, application module name and action, list of bind values, and the cursor compilation environment
Associated basic execution statistics, such as elapsed time, CPU time, buffer gets, disk reads, rows processed, cursor fetches, the number of executions, the number of complete executions, optimizer cost, and the command type
Associated execution plans and row source statistics for each SQL statement (optional)
“