The example given below shows the output for AUTOTRACE when set to ON.
下面给出的示例显示将AUTOTRACE设置为ON 时的输出。
Set AUTOTRACE ON: Produces the result set and the explain plan, and lists statistics.
真正执行查询，显示查询结果集，显示执行计划，显示统计数据。
Set AUTOTRACE TRACEONLY: Displays the explain plan and the statistics; you will not see the result set, although the statement is executed.
真正执行查询，但不显示查询结果集，显示执行计划，显示统计数据。
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 被禁用。
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 被禁用。
应用推荐