| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
DBA_HIST_PLAN_OPERATION_NAME displays historical information about SQL plan operation names.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
DBID | 
NUMBER | 
NOT NULL | 
Database identifier | 
OPERATION_ID | 
NUMBER | 
NOT NULL | 
Plan operation identifier | 
OPERATION_NAME | 
VARCHAR2(64) | 
Plan operation name. This value also appears in the SQL_PLAN_OPERATION column of the DBA_HIST_ACTIVE_SESS_HISTORY view. |