DBA_SQLTUNE_RATIONALE_PLAN
displays the association between rationales and operations in the execution plan of all SQL statements in the database.
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 |
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"