oracle 10g R2 autotrace 增强

C:\Documents and Settings\paul>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 5月 7 16:36:53 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ITPUB个人空间,F-O;N;Hi4@0F h
连接到:ITPUB个人空间R@0N)A+Y7`Il8XKcjt
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
RlK6kBF.l!Js0With the Partitioning, OLAP and Data Mining options

SQL> @ D:\oracle\product\10.2.0\db_1\rdbms\admin\utlxplan.sql

表已创建。

SQL> set autot on
C#V9cP!z G^K0SQL> select count(*) from v$session;

  COUNT(*)ITPUB个人空间-? XMVl Vs6x2}
----------ITPUB个人空间O] Bo\A*}z6D!V5L1U
        26

?N}"IYY Ueh0执行计划
#f;p
im6|r1x$L5h6o#~0----------------------------------------------------------ITPUB个人空间"sT-X
K0M~
Plan hash value: 2376410614

--------------------------------------------------------------------------------

-------------

| Id  | Operation                 | Name            | Rows  | Bytes | Cost (%CPU

)| Time     |

--------------------------------------------------------------------------------

-------------

|   0 | SELECT STATEMENT          |                 |     1 |    65 |     0   (0

)| 00:00:01 |

|   1 |  SORT AGGREGATE           |                 |     1 |    65 |
_Bp
o/r R0 |          |

|   2 |   NESTED LOOPS            |                 |     1 |    65 |     0   (0

)| 00:00:01 |

|*  3 |    FIXED TABLE FULL       | X$KSUSE         |     1 |    52 |     0   (0

)| 00:00:01 |

|*  4 |    FIXED TABLE FIXED INDEX| X$KSLED (ind:2) |     1 |    13 |     0   (0

)| 00:00:01 |

--------------------------------------------------------------------------------

-------------

T'R{%Z2uY4h0Predicate Information (identified by operation id):
#Vw9q2s:h0---------------------------------------------------

   3 - filter("S"."INST_ID"=USERENV('INSTANCE') AND BITAND("S"."KSSPAFLG",1)<>0ITPUB个人空间^iT&V:f*s+g0G
AND

              BITAND("S"."KSUSEFLG",1)<>0)ITPUB个人空间iB*f.jPE.ez@B"IW
   4 - filter("S"."KSUSEOPC"="E"."INDX")

"[*RV T+B*E~m'A0统计信息ITPUB个人空间2x#f0s*W/xW XMw[(S
----------------------------------------------------------
zA3xAs*q0          1  recursive callsITPUB个人空间]&nw%b
X3X
          0  db block gets
c;y@V8q?Vx0          0  consistent getsITPUB个人空间h2l3~b6I
          0  physical readsITPUB个人空间 GF|E)~ @u C
          0  redo size
H$Y{~.kn/^[-z0        408  bytes sent via SQL*Net to client
C,T2r a2B0        385  bytes received via SQL*Net from client
$};l@UY/Qs9n0          2  SQL*Net roundtrips to/from clientITPUB个人空间)s9Z ~#Q8[TU [
          0  sorts (memory)ITPUB个人空间N$s;oE1kB w
          0  sorts (disk)
X Y4KzX`}u\5zk(V0          1  rows processed

SQL>

以前9i 时要显示这些必须通过table(dbms_xplan.display)  工具

现在10g一步到位 呵呵