When using TKPROF to format a SQL trace file from a user session, which of the following parameters should you specify to remove recursive SQL statements from the output?
A . Explain=no
B . Sys_sql=no
C . Recursive_sql=no
D . Recursive=no
E. Sys=no
Explanation:
Answer E: Recursive SQL statements are not written to the formatted output file if you indicate the sys=no parameter and value pair. Each of the other answers are invalid parameter/value pairs.
No comments:
Post a Comment