Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
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 |
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"