../E40402-16.epub /> ../E40402-16.mobi />

DBA_HIST_PLAN_OPTION_NAME

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.