42.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)
Answer: ACD
http://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_intro.htm#RATUG167
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)
Answer: ACD
http://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_intro.htm#RATUG167
The captured SQL statements should include the following information:
-
SQL text
-
Execution environment
-
SQL binds, which are bind values needed to execute a SQL statement and generate accurate execution statistics
-
Parsing schema under which a SQL statement can be compiled
-
Compilation environment, including initialization parameters under which a SQL statement is executed
-
-
Number of times a SQL statement was executed