Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 3月 9 17:22:55 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> connect acms/acms
已连接。
SQL> create table t as select * from dba_objects;
表已创建。
SQL> desc t
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)
SQL> set autot trace
SQL> select * from t where t.object_type in ('TABLE');
已选择1431行。
执行计划
----------------------------------------------------------
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1858 | 375K| 235 (2)| 00:00:03 |
|* 1 | TABLE ACCESS FULL| T | 1858 | 375K| 235 (2)| 00:00:03 |
--------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("T"."OBJECT_TYPE"='TABLE') 这里转换为‘=’
Note
-----
- 'PLAN_TABLE' is old version
- dynamic sampling used for this statement
统计信息
----------------------------------------------------------
4 recursive calls
0 db block gets
995 consistent gets
178 physical reads
0 redo size
68980 bytes sent via SQL*Net to client
1461 bytes received via SQL*Net from client
97 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1431 rows processed