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