[Home] [Help] [Dependency Information]
Object Name: | SQL_PLAN_ALLSTAT_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) | |
EXECUTIONS | NUMBER |
|
|
LAST_STARTS | NUMBER |
|
|
STARTS | NUMBER |
|
|
LAST_OUTPUT_ROWS | NUMBER |
|
|
OUTPUT_ROWS | NUMBER |
|
|
LAST_CR_BUFFER_GETS | NUMBER |
|
|
CR_BUFFER_GETS | NUMBER |
|
|
LAST_CU_BUFFER_GETS | NUMBER |
|
|
CU_BUFFER_GETS | NUMBER |
|
|
LAST_DISK_READS | NUMBER |
|
|
DISK_READS | NUMBER |
|
|
LAST_DISK_WRITES | NUMBER |
|
|
DISK_WRITES | NUMBER |
|
|
LAST_ELAPSED_TIME | NUMBER |
|
|
ELAPSED_TIME | NUMBER |
|
|
POLICY | VARCHAR2 | (10) | |
ESTIMATED_OPTIMAL_SIZE | NUMBER |
|
|
ESTIMATED_ONEPASS_SIZE | NUMBER |
|
|
LAST_MEMORY_USED | NUMBER |
|
|
LAST_EXECUTION | VARCHAR2 | (10) | |
LAST_DEGREE | NUMBER |
|
|
TOTAL_EXECUTIONS | NUMBER |
|
|
OPTIMAL_EXECUTIONS | NUMBER |
|
|
ONEPASS_EXECUTIONS | NUMBER |
|
|
MULTIPASSES_EXECUTIONS | NUMBER |
|
|
ACTIVE_TIME | NUMBER |
|
|
MAX_TEMPSEG_SIZE | NUMBER |
|
|
LAST_TEMPSEG_SIZE | NUMBER |
|
Name | Parameters | Result |
---|---|---|
SQL_PLAN_ALLSTAT_ROW_TYPE |
SELF(SQL_PLAN_ALLSTAT_ROW_TYPE) STAT_ROW(SQL_PLAN_STAT_ROW_TYPE) |
SQL_PLAN_ALLSTAT_ROW_TYPE |
|
|
|