[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CDB_ADVISOR_SQLPLANS |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
in all containers
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TASK_NAME | VARCHAR2 | (128) | ||
| TASK_ID | NUMBER | (38) | Yes | |
| EXECUTION_NAME | VARCHAR2 | (128) | Yes | |
| SQL_ID | VARCHAR2 | (13) | Yes | |
| OBJECT_ID | NUMBER | (38) | Yes | |
| ATTRIBUTE | VARCHAR2 | (34) | ||
| STATEMENT_ID | VARCHAR2 | (30) | ||
| PLAN_HASH_VALUE | NUMBER | Yes | ||
| PLAN_ID | NUMBER | Yes | ||
| TIMESTAMP | DATE | |||
| REMARKS | VARCHAR2 | (4000) | ||
| OPERATION | VARCHAR2 | (30) | ||
| OPTIONS | VARCHAR2 | (255) | ||
| OBJECT_NODE | VARCHAR2 | (128) | ||
| OBJECT_OWNER | VARCHAR2 | (128) | ||
| OBJECT_NAME | VARCHAR2 | (128) | ||
| OBJECT_ALIAS | VARCHAR2 | (261) | ||
| OBJECT_INSTANCE | NUMBER | (38) | ||
| OBJECT_TYPE | VARCHAR2 | (30) | ||
| OPTIMIZER | VARCHAR2 | (255) | ||
| SEARCH_COLUMNS | NUMBER | |||
| ID | NUMBER | (38) | Yes | |
| PARENT_ID | NUMBER | (38) | ||
| DEPTH | NUMBER | (38) | ||
| POSITION | NUMBER | (38) | ||
| COST | NUMBER | (38) | ||
| CARDINALITY | NUMBER | (38) | ||
| BYTES | NUMBER | (38) | ||
| OTHER_TAG | VARCHAR2 | (255) | ||
| PARTITION_START | VARCHAR2 | (255) | ||
| PARTITION_STOP | VARCHAR2 | (255) | ||
| PARTITION_ID | NUMBER | (38) | ||
| DISTRIBUTION | VARCHAR2 | (30) | ||
| CPU_COST | NUMBER | (38) | ||
| IO_COST | NUMBER | (38) | ||
| TEMP_SPACE | NUMBER | (38) | ||
| ACCESS_PREDICATES | VARCHAR2 | (4000) | ||
| FILTER_PREDICATES | VARCHAR2 | (4000) | ||
| PROJECTION | VARCHAR2 | (4000) | ||
| TIME | NUMBER | (38) | ||
| QBLOCK_NAME | VARCHAR2 | (128) | ||
| OTHER_XML | CLOB | (4000) | ||
| CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_NAME
, TASK_ID
, EXECUTION_NAME
, SQL_ID
, OBJECT_ID
, ATTRIBUTE
, STATEMENT_ID
, PLAN_HASH_VALUE
, PLAN_ID
, TIMESTAMP
, REMARKS
, OPERATION
, OPTIONS
, OBJECT_NODE
, OBJECT_OWNER
, OBJECT_NAME
, OBJECT_ALIAS
, OBJECT_INSTANCE
, OBJECT_TYPE
, OPTIMIZER
, SEARCH_COLUMNS
, ID
, PARENT_ID
, DEPTH
, POSITION
, COST
, CARDINALITY
, BYTES
, OTHER_TAG
, PARTITION_START
, PARTITION_STOP
, PARTITION_ID
, DISTRIBUTION
, CPU_COST
, IO_COST
, TEMP_SPACE
, ACCESS_PREDICATES
, FILTER_PREDICATES
, PROJECTION
, TIME
, QBLOCK_NAME
, OTHER_XML
, CON_ID
FROM SYS.CDB_ADVISOR_SQLPLANS;
SYS.CDB_ADVISOR_SQLPLANS does not reference any database object
SYS.CDB_ADVISOR_SQLPLANS is referenced by following:
PUBLIC
CDB_ADVISOR_SQLPLANS
|
|
|
|