| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| STATEMENT_ID |
varchar2 |
30 |
√ |
|
null |
|
|
| PLAN_ID |
number |
0 |
√ |
|
null |
|
|
| TIMESTAMP |
date |
7 |
√ |
|
null |
|
|
| REMARKS |
varchar2 |
4000 |
√ |
|
null |
|
|
| OPERATION |
varchar2 |
30 |
√ |
|
null |
|
|
| OPTIONS |
varchar2 |
255 |
√ |
|
null |
|
|
| OBJECT_NODE |
varchar2 |
128 |
√ |
|
null |
|
|
| OBJECT_OWNER |
varchar2 |
30 |
√ |
|
null |
|
|
| OBJECT_NAME |
varchar2 |
30 |
√ |
|
null |
|
|
| OBJECT_ALIAS |
varchar2 |
65 |
√ |
|
null |
|
|
| OBJECT_INSTANCE |
number |
0 |
√ |
|
null |
|
|
| OBJECT_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| OPTIMIZER |
varchar2 |
255 |
√ |
|
null |
|
|
| SEARCH_COLUMNS |
number |
0 |
√ |
|
null |
|
|
| ID |
number |
0 |
√ |
|
null |
|
|
| PARENT_ID |
number |
0 |
√ |
|
null |
|
|
| DEPTH |
number |
0 |
√ |
|
null |
|
|
| POSITION |
number |
0 |
√ |
|
null |
|
|
| COST |
number |
0 |
√ |
|
null |
|
|
| CARDINALITY |
number |
0 |
√ |
|
null |
|
|
| BYTES |
number |
0 |
√ |
|
null |
|
|
| OTHER_TAG |
varchar2 |
255 |
√ |
|
null |
|
|
| PARTITION_START |
varchar2 |
255 |
√ |
|
null |
|
|
| PARTITION_STOP |
varchar2 |
255 |
√ |
|
null |
|
|
| PARTITION_ID |
number |
0 |
√ |
|
null |
|
|
| OTHER |
long |
0 |
√ |
|
null |
|
|
| DISTRIBUTION |
varchar2 |
30 |
√ |
|
null |
|
|
| CPU_COST |
number |
0 |
√ |
|
null |
|
|
| IO_COST |
number |
0 |
√ |
|
null |
|
|
| TEMP_SPACE |
number |
0 |
√ |
|
null |
|
|
| ACCESS_PREDICATES |
varchar2 |
4000 |
√ |
|
null |
|
|
| FILTER_PREDICATES |
varchar2 |
4000 |
√ |
|
null |
|
|
| PROJECTION |
varchar2 |
4000 |
√ |
|
null |
|
|
| TIME |
number |
0 |
√ |
|
null |
|
|
| QBLOCK_NAME |
varchar2 |
30 |
√ |
|
null |
|
|
| OTHER_XML |
clob |
4000 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|