1·The example given below shows the output for AUTOTRACE when set to ON.
下面给出的示例显示将 AUTOTRACE 设置为 ON 时的输出。
2·Set AUTOTRACE ON: Produces the result set and the explain plan, and lists statistics.
真正执行查询,显示查询结果集,显示执行计划,显示统计数据。
3·Set AUTOTRACE TRACEONLY: Displays the explain plan and the statistics; you will not see the result set, although the statement is executed.
真正执行查询,但不显示查询结果集,显示执行计划,显示统计数据。
4·Setting the AUTOTRACE option ON will enable the display of explain and statistics information for each statement executed in that session along with query results, until the AUTOTRACE is disabled.
将 AUTOTRACE 选项设置为 ON 将允许显示该会话中执行的每条语句的说明和统计信息,以及查询结果,直至 AUTOTRACE 被禁用。