COLUMN_NAME |
DATA_TYPE |
NULLABLE |
DATA_DEFAULT |
COLUMN_ID |
COMMENTS |
STATEMENT_ID |
VARCHAR2(30 BYTE) |
Yes |
null |
1 |
null |
TIMESTAMP |
DATE |
Yes |
null |
2 |
null |
REMARKS |
VARCHAR2(80 BYTE) |
Yes |
null |
3 |
null |
OPERATION |
VARCHAR2(30 BYTE) |
Yes |
null |
4 |
null |
OPTIONS |
VARCHAR2(255 BYTE) |
Yes |
null |
5 |
null |
OBJECT_NODE |
VARCHAR2(128 BYTE) |
Yes |
null |
6 |
null |
OBJECT_OWNER |
VARCHAR2(30 BYTE) |
Yes |
null |
7 |
null |
OBJECT_NAME |
VARCHAR2(30 BYTE) |
Yes |
null |
8 |
null |
OBJECT_INSTANCE |
NUMBER |
Yes |
null |
9 |
null |
OBJECT_TYPE |
VARCHAR2(30 BYTE) |
Yes |
null |
10 |
null |
OPTIMIZER |
VARCHAR2(255 BYTE) |
Yes |
null |
11 |
null |
SEARCH_COLUMNS |
NUMBER |
Yes |
null |
12 |
null |
ID |
NUMBER |
Yes |
null |
13 |
null |
PARENT_ID |
NUMBER |
Yes |
null |
14 |
null |
POSITION |
NUMBER |
Yes |
null |
15 |
null |
COST |
NUMBER |
Yes |
null |
16 |
null |
CARDINALITY |
NUMBER |
Yes |
null |
17 |
null |
BYTES |
NUMBER |
Yes |
null |
18 |
null |
OTHER_TAG |
VARCHAR2(255 BYTE) |
Yes |
null |
19 |
null |
PARTITION_START |
VARCHAR2(255 BYTE) |
Yes |
null |
20 |
null |
PARTITION_STOP |
VARCHAR2(255 BYTE) |
Yes |
null |
21 |
null |
PARTITION_ID |
NUMBER |
Yes |
null |
22 |
null |
OTHER |
LONG |
Yes |
null |
23 |
null |
DISTRIBUTION |
VARCHAR2(30 BYTE) |
Yes |
null |
24 |
null |
CPU_COST |
NUMBER(38,0) |
Yes |
null |
25 |
null |
IO_COST |
NUMBER(38,0) |
Yes |
null |
26 |
null |
TEMP_SPACE |
NUMBER(38,0) |
Yes |
null |
27 |
null |
ACCESS_PREDICATES |
VARCHAR2(4000 BYTE) |
Yes |
null |
28 |
null |
FILTER_PREDICATES |
VARCHAR2(4000 BYTE) |
Yes |
null |
29 |
null |