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一步到位 呵呵
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-263020/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE 10G AUTOTRACEOracle 10g
- oracle 10g merge命令的增強Oracle 10g
- Oracle 10g中對resumable session的增強Oracle 10gSession
- oracle 10g R2 dataguardOracle 10g
- Library cache pin/lock 在Oracle 10g的增強Oracle 10g
- Oracle 10G R2 RAC 日常管理Oracle 10g
- Oracle 10G R2 RAC日常管理Oracle 10g
- oracle 10g R2 drop empty datafileOracle 10g
- oracle 10g r2 ASM RAC on aixOracle 10gASMAI
- Oracle AutotraceOracle
- oracle 10g 增強審計。表insert 及bind valuesOracle 10g
- 10G DBNEWID工具的增強
- oracle 10g 增強審計(二)----細粒度訪問審計Oracle 10g
- 【oracle 10g R2 新特性】Asynchronous CommitOracle 10gMIT
- Oracle Data Guard 10g R2概念和理論Oracle
- oracle 10g R2 Block change tracking 新特性Oracle 10gBloC
- ORACLE 10g R2及PATH官方下載地址Oracle 10g
- 關於ORACLE AUTOTRACEOracle
- ORACLE 使用AUTOTRACE功能Oracle
- Oracle 10g 增刪節點Oracle 10g
- Oracle 10g R2建立ASM例項Step By Step(一)Oracle 10gASM
- Oracle 10g R2建立ASM例項Step By Step(四)Oracle 10gASM
- Linux (RHEL 5.4)下安裝 Oracle 10g R2LinuxOracle 10g
- oracle 10g r2新功能可以跨越resetlogs 恢復Oracle 10g
- Oracle12c功能增強 新特性之管理功能的增強Oracle
- Oracle最佳化工具——AutoTraceOracle
- Oracle 10g R2 for RHEL AS4 安裝重點小記Oracle 10g
- ORACLE 12C RMAN 功能增強Oracle
- Oracle 10g R2新特性之備份和可用性特性Oracle 10g
- oracle之autotrace統計資訊分析Oracle
- oracle 9i 開啟autotrace onOracle
- Oracle 9I 下的AutoTraceOracle
- 【優化】ORACLE set autotrace in SQL*Plus優化OracleSQL
- oracle 10G R2 RAC 資料庫的關閉與啟動(ZT)Oracle 10g資料庫
- Oracle 10G R2在Linux X86_64下的安裝Oracle 10gLinux
- oracle 10g 監聽安全機制的加強Oracle 10g
- oracle實驗記錄 (oracle 10G dbms_xplan的強化)Oracle
- Oracle11新特性——分割槽功能增強Oracle