| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
DBA_ADVISOR_SQLPLANS displays a list of all SQL execution plans.
Related View
USER_ADVISOR_SQLPLANS displays a list of all SQL execution plans owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TASK_NAME |
VARCHAR2(30) |
??? | |
TASK_ID |
NUMBER(38) |
NOT NULL |
??? |
EXECUTION_NAME |
VARCHAR2(30) |
NOT NULL |
The name of the task execution with which this entry (row) is associated |
OBJECT_ID |
NUMBER(38) |
NOT NULL |
??? |
ATTRIBUTE |
VARCHAR2(27) |
??? | |
STATEMENT_ID |
VARCHAR2(30) |
??? | |
PLAN_HASH_VALUE |
NUMBER |
NOT NULL |
??? |
PLAN_ID |
NUMBER |
NOT NULL |
??? |
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 |
NUMBER(38) |
??? | |
OBJECT_TYPE |
VARCHAR2(30) |
??? | |
OPTIMIZER |
VARCHAR2(255) |
??? | |
SEARCH_COLUMNS |
NUMBER |
??? | |
ID |
NUMBER(38) |
NOT NULL |
??? |
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) |
??? | |
OTHER |
LONG |
??? | |
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(30) |
??? | |
OTHER_XML |
CLOB |
??? |
