| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
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_OPTIONScolumn of theDBA_HIST_ACTIVE_SESS_HISTORYview. |