oracle,Cannot SET AUTOTRACE解决问题

来源：互联网发布：软件项目质量计划书编辑：程序博客网时间：2024/05/01 08:17

1、SET AUTOTRACE参数

SET AUTOTRACE OFF ---------------- 不生成AUTOTRACE 报告，这是缺省模式
SET AUTOTRACE ON EXPLAIN ------ AUTOTRACE只显示优化器执行路径报告
SET AUTOTRACE ON STATISTICS -- 只显示执行统计信息
SET AUTOTRACE ON ----------------- 包含执行计划和统计信息
SET AUTOTRACE TRACEONLY ------ 同set autotrace on，但是不显示查询输出

2、只能在sql plus下执行

SQL> SET AUTOTRACE ON;
SQL> select count(*) from oz_member;

COUNT(*)
----------
472

执行计划
----------------------------------------------------------

-------------------------------------------------------
| Id | Operation        | Name | Rows | Cost (%CPU)|
-------------------------------------------------------
|   0 | SELECT STATEMENT |       |     1 |     1   (0)|
|   1 | SORT AGGREGATE |       |     1 |            |
|   2 |   INDEX FULL SCAN| PK1_1 |   472 |     1   (0)|
-------------------------------------------------------

Note
-----
- 'PLAN_TABLE' is old version

统计信息
----------------------------------------------------------
        193 recursive calls
          0 db block gets
         34 consistent gets
          0 physical reads
          0 redo size
        409 bytes sent via SQL*Net to client
        385 bytes received via SQL*Net from client
          2 SQL*Net roundtrips to/from client
          0 sorts (memory)
          0 sorts (disk)
          1 rows processed、