oracle 10g R2 autotrace 增强

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:36

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.

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @ D:\oracle\product\10.2.0\db_1\rdbms\admin\utlxplan.sql
表已创建。
SQL> set autot on
SQL> select count(*) from v$session;
COUNT(*)
----------
26

执行计划
----------------------------------------------------------
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 |
| |
| 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 |
--------------------------------------------------------------------------------
-------------

Predicate Information (identified by operation id):
---------------------------------------------------
3 - filter("S"."INST_ID"=USERENV('INSTANCE') AND BITAND("S"."KSSPAFLG",1)<>0
AND
BITAND("S"."KSUSEFLG",1)<>0)
4 - filter("S"."KSUSEOPC"="E"."INDX")

统计信息
----------------------------------------------------------
1 recursive calls
0 db block gets
0 consistent gets
0 physical reads
0 redo size
408 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
SQL>
以前9i 时要显示这些必须通过table(dbms_xplan.display) 工具
现在10g一步到位 呵呵

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】