1:set autotrace on; 显示:记录集+explain+statistics 2:set autotrace on explain 显示:记录集+explain 3:set autotrace on statistic 显示:记录集+statistics 4:set autotrace traceonly 显示: expain+statistics(不显示数据) 5:set autotrace traceonly statistics 显示: statistics 6:set autotrace traceonly ex...
默认值为OFF。 SET AUTOTRACE OFF:不生成AUTOTRACE报告,这是缺省模式 SET AUTOTRACE ON EXPLAIN:AUTOTRACE只显示优化器执行路径报告 SET AUTOTRACE ON STATISTICS:只显示执行统计信息 SET AUTOTRACE ON:包含执行计划和统计信息 SET AUTOTRACE TRACEONLY:同SET AUTOTRACE ON,但是不显示查询输出 3SET TRIMOUT ON 去除...
set autotrace on statistics set autotrace on explain statistics set autotrace traceonly explain set autotrace traceonly statistics set autotrace traceonly explain statistics set autotrace off explain set autotrace off statistics set autotrace off explain statistics 设置autotrace允许显示DML语句的一些统计信...
1:set autotrace on; 显示:记录集+explain+statistics 2:set autotrace on explain 显示:记录集+explain 3:set autotrace on statistic 显示:记录集+statistics 4:set autotrace traceonly 显示: expain+statistics(不显示数据) 5:set autotrace traceonly statistics 显示: statistics 6:set autotrace traceonly ex...
SQL> set autotrace traceonly explain SQL> select * from dual; 执行计划 --- Plan hashvalue:272002086 --- | Id |Operation| Name |Rows| Bytes |Cost (%CPU)| Time | ---
2、autotrace的使用方法 --SET AUTOTRACE OFF 此为默认值,即关闭Autotrace --SET AUTOTRACE ON EXPLAIN 只显示执行计划 --SET AUTOTRACE ON STATISTICS 只显示执行的统计信息 --SET AUTOTRACE ON 包含2,3两项内容 --SET AUTOTRACE TRACEONLY 与ON相似,但不显示语句的执行结果。
SET AUTOTRACE ON EXPLAIN --- AUTOTRACE只显示优化器执行路径报告 SET AUTOTRACE ON STATISTICS --- 只显示执行统计信息 SET AUTOTRACE ON --- 包含执行计划和统计信息 SET AUTOTRACE TRACEONLY --- 同set autotrace on,但是不显示查询输出
4:set autotrace traceonly 显示: expain+statistics(不显示数据) 5:set autotrace traceonly statistics 显示: statistics 6:set autotrace traceonly explain 显示: explain 7:set autotrace off 显示:只显示记录集,这也就是默认的SQL PLUS的窗口效果
SET AUTOTRACE OFF：不⽣成AUTOTRACE 报告。这是缺省模式 SET AUTOTRACE ON EXPLAIN：AUTOTRACE仅仅显⽰优化器运⾏路径报告 SET AUTOTRACE ON STATISTICS：仅仅显⽰运⾏统计信息 SET AUTOTRACE ON：包括运⾏计划和统计信息 SET AUTOTRACE TRACEONLY：同SET AUTOTRACE ON，可是不显⽰查询输出 3 去除标准...
EXPLAIN --- AUTOTRACE只显示优化器执行路径报告 SET AUTOTRACE ON STATISTICS -- 只显示执行统计信息 SET AUTOTRACE ON --- 包含执行计划和统计信息 SET AUTOTRACE TRACEONLY --- 同set autotrace on，但是不显示查询输出 在ORACLE的SQLPLUS里用 输入命令回车就行了 ...