DBA_SQLTUNE_RATIONALE

5.379 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(128)`	`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(34)`		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