DBA_HIST_PLAN_OPTION_NAME

DBA_HIST_PLAN_OPTION_NAME contains a list of row source options

In Oracle 12.1.0.2 DBA_HIST_PLAN_OPTION_NAME has the following columns:

NameData Type
DBIDNUMBER
OPTION_IDNUMBER
OPTION_NAMEVARCHAR2(64)
CON_DBIDNUMBER
CON_IDNUMBER

The following table summarizes the number of options in various releases:

Version # Options
11.2.0.3 165
12.1.0.2 219