[Home] [Help] [Dependency Information]
Object Name: | SQL_PLAN_ROW_TYPE |
---|---|
Object Type: | TYPE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
STATEMENT_ID | VARCHAR2 | (30) | |
PLAN_ID | NUMBER |
|
|
TIMESTAMP | DATE |
|
|
REMARKS | VARCHAR2 | (4000) | |
OPERATION | VARCHAR2 | (30) | |
OPTIONS | VARCHAR2 | (255) | |
OBJECT_NODE | VARCHAR2 | (128) | |
OBJECT_OWNER | VARCHAR2 | (30) | |
OBJECT_NAME | VARCHAR2 | (30) | |
OBJECT_ALIAS | VARCHAR2 | (65) | |
OBJECT_INSTANCE | DECIMAL |
|
|
OBJECT_TYPE | VARCHAR2 | (30) | |
OPTIMIZER | VARCHAR2 | (255) | |
SEARCH_COLUMNS | NUMBER |
|
|
ID | DECIMAL |
|
|
PARENT_ID | DECIMAL |
|
|
DEPTH | DECIMAL |
|
|
POSITION | DECIMAL |
|
|
COST | DECIMAL |
|
|
CARDINALITY | DECIMAL |
|
|
BYTES | DECIMAL |
|
|
OTHER_TAG | VARCHAR2 | (255) | |
PARTITION_START | VARCHAR2 | (255) | |
PARTITION_STOP | VARCHAR2 | (255) | |
PARTITION_ID | DECIMAL |
|
|
DISTRIBUTION | VARCHAR2 | (30) | |
CPU_COST | DECIMAL |
|
|
IO_COST | DECIMAL |
|
|
TEMP_SPACE | DECIMAL |
|
|
ACCESS_PREDICATES | VARCHAR2 | (4000) | |
FILTER_PREDICATES | VARCHAR2 | (4000) | |
PROJECTION | VARCHAR2 | (4000) | |
TIME | DECIMAL |
|
|
QBLOCK_NAME | VARCHAR2 | (30) | |
OTHER_XML | CLOB | (0) |
|
|
|