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. |