| 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_OPTIONS column of the DBA_HIST_ACTIVE_SESS_HISTORY view. |