SQL> desc col
Name Null? Type
------------------------------------------------------------------------ -------- ------------------------------
TNAME NOT NULL VARCHAR2(30)
COLNO NOT NULL NUMBER
CNAME NOT NULL VARCHAR2(30)
COLTYPE VARCHAR2(106)
WIDTH NOT NULL NUMBER
SCALE NUMBER
PRECISION NUMBER
NULLS VARCHAR2(19)
DEFAULTVAL LONG
CHARACTER_SET_NAME VARCHAR2(44)
SQL> explain plan for select tname,colno,cname from col;
Explained.
Elapsed: 00:00:00.29
SQL> select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------------------------------------
Plan hash value: 4272774126
---------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 5242 | 470K| 331 (3)| 00:00:04 |
|* 1 | HASH JOIN RIGHT OUTER | | 5242 | 470K| 331 (3)| 00:00:04 |
| 2 | TABLE ACCESS FULL | USER$ | 38 | 114 | 2 (0)| 00:00:01 |
|* 3 | HASH JOIN RIGHT OUTER | | 5242 | 455K| 329 (3)| 00:00:04 |
| 4 | TABLE ACCESS FULL | OBJ$ | 13726 | 82356 | 48 (5)| 00:00:01 |
| 5 | NESTED LOOPS OUTER | | 5242 | 424K| 280 (2)| 00:00:04 |
| 6 | NESTED LOOPS | | 5242 | 291K| 123 (2)| 00:00:02 |
|* 7 | TABLE ACCESS FULL | OBJ$ | 323 | 9690 | 48 (5)| 00:00:01 |
|* 8 | TABLE ACCESS CLUSTER | COL$ | 16 | 432 | 1 (0)| 00:00:01 |
|* 9 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | 0 (0)| 00:00:01 |
| 10 | TABLE ACCESS BY INDEX ROWID| COLTYPE$ | 1 | 26 | 1 (0)| 00:00:01 |
|* 11 | INDEX UNIQUE SCAN | I_COLTYPE2 | 1 | | 0 (0)| 00:00:01 |
---------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("OT"."OWNER#"="UT"."USER#"(+))
3 - access("AC"."TOID"="OT"."OID$"(+))
7 - filter(("T"."TYPE#"=2 OR "T"."TYPE#"=3 OR "T"."TYPE#"=4) AND
"T"."OWNER#"=USERENV('SCHEMAID'))
8 - filter(BITAND("C"."PROPERTY",32)=0)
9 - access("T"."OBJ#"="C"."OBJ#")
11 - access("C"."OBJ#"="AC"."OBJ#"(+) AND "C"."INTCOL#"="AC"."INTCOL#"(+))
29 rows selected.
Elapsed: 00:00:01.92