Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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
EXECUTION_NAME VARCHAR2(30) NOT NULL The name of the task execution with which this entry (row) is associated
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