![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
网络转载
LoveOracle520
这个作者很懒,什么都没留下…
展开
-
如何看懂ORACLE执行计划
一、什么是执行计划An explain plan is a representation of the access path that is taken when a query is executed within Oracle.二、如何访问数据At the physical level Oracle reads blocks of data. The smallest amoun转载 2016-08-31 17:22:31 · 478 阅读 · 0 评论 -
SET AUTOTRACE
SET AUTOTRACE OFF 此为默认值,即关闭Autotrace SET AUTOTRACE ON EXPLAIN 只显示执行计划SET AUTOTRACE ON STATISTICS 只显示执行的统计信息SET AUTOTRACE ON 包含2,3两项内容SET AUTOTRACE TRACEONLY 与ON相似,但不显示语句的执行结果转载 2016-08-31 17:31:29 · 197 阅读 · 0 评论