DBA_SQLTUNE_RATIONALE_PLAN

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:

  • Original - Original plan of the query

  • Original with adjusted cost - Same as Original but with adjusted cost

  • Using SQL profile - Plan with sql profile applied

  • Using new indices - Plan with indexes applied

See Also:

"USER_SQLTUNE_RATIONALE_PLAN"