oracle,Cannot SET AUTOTRACE解決問題__oracle

 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、