| 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_SQLTUNE_RATIONALE_PLAN displays the association between rationales and operations in the execution plan of all SQL statements in the database.
Related View
USER_SQLTUNE_RATIONALE_PLAN displays the association between rationales and operations in the execution plan of the SQL statements owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TASK_ID |
NUMBER(38) |
NOT NULL |
Tuning task identifier |
EXECUTION_NAME |
VARCHAR2(30) |
NOT NULL |
??? |
RATIONALE_ID |
NUMBER(38) |
NOT NULL |
Rationale identifier |
OBJECT_ID |
NUMBER(38) |
NOT NULL |
Advisor framework object identifier |
OPERATION_ID |
NUMBER(38) |
NOT NULL |
Operation identifier |
PLAN_ATTRIBUTE |
VARCHAR2(27) |
Type of the execution plan:
|
See Also:
"USER_SQLTUNE_RATIONALE_PLAN"
