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:
Name | Data Type |
DBID | NUMBER |
OPTION_ID | NUMBER |
OPTION_NAME | VARCHAR2(64) |
CON_DBID | NUMBER |
CON_ID | NUMBER |
The following table summarizes the number of options in various releases:
Version | # Options |
11.2.0.3 | 165 |
12.1.0.2 | 219 |