DBA_HIST_PLAN_OPTION_NAME displays historical information about SQL plan option names.
| Column | Datatype | NULL | Description |
|---|---|---|---|
DBID |
NUMBER |
NOT NULL |
Database identifier |
OPTION_ID |
NUMBER |
NOT NULL |
Plan option identifier |
OPTION_NAME |
VARCHAR2(64) |
Plan option name. This value also appears in the SQL_PLAN_OPTIONS column of the DBA_HIST_ACTIVE_SESS_HISTORY view. |